Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.postgresql > #386
| Path | csiph.com!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| From | Greg Hennessy <greg.hennessy@cox.net> |
| Newsgroups | comp.databases.postgresql |
| Subject | Re: scan into many tables |
| Date | Fri, 13 Jul 2012 20:48:24 +0000 (UTC) |
| Organization | A noiseless patient Spider |
| Lines | 17 |
| Message-ID | <jtq1io$ef8$1@dont-email.me> (permalink) |
| References | <jtphan$934$1@dont-email.me> <a6b16bFpc5U1@mid.individual.net> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=us-ascii |
| Content-Transfer-Encoding | 7bit |
| Injection-Date | Fri, 13 Jul 2012 20:48:24 +0000 (UTC) |
| Injection-Info | mx04.eternal-september.org; posting-host="9b7bc6154893da76f7357e62763374a4"; logging-data="14824"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/zzO4vrDcy/1Fsyl+6fXRcvq2JAtw+CU0=" |
| User-Agent | slrn/0.9.9p1 (Linux) |
| Cancel-Lock | sha1:f1J7cFSBkV3NpSiAMrQcT/JuF4E= |
| Xref | csiph.com comp.databases.postgresql:386 |
Show key headers only | View raw
On 2012-07-13, Hans Castorp <REWYRLXHEGHO@spammotel.com> wrote:
> That sounds like something is seriously broken in your
> environment. How many rows are we talking?
28 billion rows, if I understand things correctly.
PS1=# explaPS1=# explain select count(*) from centroids;
QUERY PLAN
---------------------------------------------------------------------------------
Aggregate (cost=688839322.40..688839322.41 rows=1 width=0)
-> Seq Scan on centroids (cost=0.00..616676434.72 rows=28865155072 width=0)
(2 rows)
Time: 3468.272 ms
PS1=#
Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
scan into many tables Greg Hennessy <greg.hennessy@cox.net> - 2012-07-13 16:11 +0000
Re: scan into many tables Hans Castorp <REWYRLXHEGHO@spammotel.com> - 2012-07-13 18:37 +0200
Re: scan into many tables Greg Hennessy <greg.hennessy@cox.net> - 2012-07-13 18:54 +0000
Re: scan into many tables Greg Hennessy <greg.hennessy@cox.net> - 2012-07-13 20:48 +0000
Re: scan into many tables Matthew Woodcraft <mattheww@chiark.greenend.org.uk> - 2012-07-13 17:51 +0100
Re: scan into many tables Greg Hennessy <greg.hennessy@cox.net> - 2012-07-13 19:00 +0000
Re: scan into many tables Matthew Woodcraft <mattheww@chiark.greenend.org.uk> - 2012-07-13 22:15 +0100
Re: scan into many tables Graham Murray <newspost@gmurray.org.uk> - 2012-07-22 11:46 +0100
Re: scan into many tables Matthew Woodcraft <mattheww@chiark.greenend.org.uk> - 2012-07-22 13:09 +0100
Re: scan into many tables Robert Klemme <shortcutter@googlemail.com> - 2012-07-22 18:55 +0200
Re: scan into many tables Matthew Woodcraft <mattheww@chiark.greenend.org.uk> - 2012-07-22 21:07 +0100
Re: scan into many tables Don Y <this@isnotme.com> - 2012-07-22 10:30 -0700
Re: scan into many tables Hans Castorp <REWYRLXHEGHO@spammotel.com> - 2012-07-22 20:24 +0200
Re: scan into many tables Don Y <this@isnotme.com> - 2012-07-22 12:54 -0700
Re: scan into many tables Greg Hennessy <greg.hennessy@cox.net> - 2012-07-22 22:57 +0000
Re: scan into many tables Jasen Betts <jasen@xnet.co.nz> - 2012-07-14 02:55 +0000
csiph-web