Hi list,
I don't have much experience with Postgres optimization, somehow I was
happily avoiding anything more difficult than simple select statement,
and it was working all right.
Now LEFT JOIN must be used, and I am not happy with the performance:
It takes about 5 seconds to run very simple LEF
2005/9/12, Stephen Frost <[EMAIL PROTECTED]>:
> * Ksenia Marasanova ([EMAIL PROTECTED]) wrote:
> > Any tips are greatly appreciated.
>
> EXPLAIN ANALYZE of the same queries would be much more useful.
Thanks, here it is:
test=# explain analyze select * from user_ left
Hi,
I have a strange problem with my Postgres application. The problem is
that the data entered in the application never reaches the database,
although the record id (serial) is generated, and the record can be
retrieved again, and be modified. Multiple records can be added and
modified. But when
Hi,
Alfter hours of adjusting performance of the queries in my Postgres
7.3 database - reprogramming the queries, VACUUMing, changing value of
enable_seqscan - I gived it up, recreated the database and transferred
the dump of the old database into it.
The queries went from 15 sec to 50 msec!! Wow