Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.postgresql > #386
| From | Greg Hennessy <greg.hennessy@cox.net> |
|---|---|
| Newsgroups | comp.databases.postgresql |
| Subject | Re: scan into many tables |
| Date | 2012-07-13 20:48 +0000 |
| Organization | A noiseless patient Spider |
| Message-ID | <jtq1io$ef8$1@dont-email.me> (permalink) |
| References | <jtphan$934$1@dont-email.me> <a6b16bFpc5U1@mid.individual.net> |
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