Re: [PERFORM] what is the maximum number of rows in a table in postgresql 8.1

2008-03-26 Thread Matthew
th maximum number of records in one PostreSQL table ist unlimited: am asking for good performance, not just limitation.. If i have half a crore record, how the performance will be ? How long is a piece of string? It depends what you are doing, whether you have indexes, how the tables are ar

Re: [PERFORM] what is the maximum number of rows in a table in postgresql 8.1

2008-03-25 Thread Bill Moran
In response to "sathiya psql" <[EMAIL PROTECTED]>: > EXPLAIN ANALYZE SELECT count(*) from call_log_in_ram ; > QUERY > PLAN > -

Re: [PERFORM] what is the maximum number of rows in a table in postgresql 8.1

2008-03-25 Thread Ivan Voras
sathiya psql wrote: > EXPLAIN ANALYZE SELECT count(*) from call_log_in_ram ; > QUERY > PLAN > > --

Re: [PERFORM] what is the maximum number of rows in a table in postgresql 8.1

2008-03-25 Thread Craig Ringer
sathiya psql wrote: EXPLAIN ANALYZE SELECT count(*) from call_log_in_ram ; And your usual query is: SELECT count(*) from call_log_in_ram; ? If so, you should definitely build a summary table maintained by a trigger to track the row count. That's VERY well explained in the mailing list ar

Re: [PERFORM] what is the maximum number of rows in a table in postgresql 8.1

2008-03-25 Thread sathiya psql
EXPLAIN ANALYZE SELECT count(*) from call_log_in_ram ; QUERY PLAN -- Aggregate (cost=90760.80..90760.80 rows=

Re: [PERFORM] what is the maximum number of rows in a table in postgresql 8.1

2008-03-25 Thread Craig Ringer
sathiya psql wrote: yes many a times i need to process all the records, often i need to use count(*) so what to do ?? ( those trigger options i know already, but i wil l do count on different parameters ) *** PLEASE *** post the output of an EXPLAIN ANALYSE on one or more of your querie

Re: [PERFORM] what is the maximum number of rows in a table in postgresql 8.1

2008-03-25 Thread sathiya psql
> > > > Shows us the explain analyze. There is no problem with a large number > of records, as long as you're not expecting to process all of them all > the time. yes many a times i need to process all the records, often i need to use count(*) so what to do ?? ( those trigger options i kn

Re: [PERFORM] what is the maximum number of rows in a table in postgresql 8.1

2008-03-25 Thread Alvaro Herrera
sathiya psql escribió: > I have 1 GB RAM with Pentium Celeron. > 50 lakh records and postgres performance is not good > > It takes 30 sec for simple queries Shows us the explain analyze. There is no problem with a large number of records, as long as you're not expecting to process all o

Re: [PERFORM] what is the maximum number of rows in a table in postgresql 8.1

2008-03-25 Thread sathiya psql
> > th maximum number of records in one PostreSQL table ist unlimited: > am asking for good performance, not just limitation.. If i have half a crore record, how the performance will be ? > > http://www.postgresql.org/about/ > > [for some values of unlimited] > > Some further help: > > googling f

Re: [PERFORM] what is the maximum number of rows in a table in postgresql 8.1

2008-03-25 Thread Harald Armin Massa
Sathiya, th maximum number of records in one PostreSQL table ist unlimited: http://www.postgresql.org/about/ [for some values of unlimited] Some further help: googling for: postgresql limits site:postgresql.org leads you to this answer quite quick, while googling for maximum number of rows i