Re: [GENERAL] Cost problem

On Tue, 2005-08-02 at 17:32 +0300, Victor wrote: > Hello. > > I use psql (PostgreSQL) 7.4.5. > > I have a cost problem. > > A simple select lasts too long. > I have a table with aprox 900 rows. > All rows are deleted and reinserted once a minute. > > EXPLAIN ANALYZE SELECT * FROM logati; >

Re: [GENERAL] Cost problem

On 8/2/05, Victor <[EMAIL PROTECTED]> wrote: > Hello. > > I use psql (PostgreSQL) 7.4.5. > > I have a cost problem. > > A simple select lasts too long. > I have a table with aprox 900 rows. > All rows are deleted and reinserted once a minute. > > EXPLAIN SELECT * FROM logati; >

[GENERAL] Cost problem

Hello. I use psql (PostgreSQL) 7.4.5. I have a cost problem. A simple select lasts too long. I have a table with aprox 900 rows. All rows are deleted and reinserted once a minute. EXPLAIN SELECT * FROM logati; QUERY PLAN --