I have a table with 17 columns and it has almost
530000 records and doing just a
SELECT * FROM table
with the EXPLAIN ANALYZE I get:
Seq Scan on table (cost=0.00...19452.95 rows=529395
width=170) (actual time=0.155...2194.294 rows=529395
total runtime=3679.039 ms
and this table has a PK...
Do you think is too much time for a simple select?...
I guess it's a bit slow to get all those records...but
since I'm a newbie with PostgreSQL, what I can check
Thanks to all!
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
pgsql-performance by date
|Next:||From: Pavan Deolasee||Date: 2008-04-09 10:04:06|
|Subject: Re: EXPLAIN detail|
|Previous:||From: PFC||Date: 2008-04-08 22:48:35|
|Subject: Re: bulk insert performance problem|