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
In response to "sathiya psql" <[EMAIL PROTECTED]>:
> EXPLAIN ANALYZE SELECT count(*) from call_log_in_ram ;
> QUERY
> PLAN
> -
sathiya psql wrote:
> EXPLAIN ANALYZE SELECT count(*) from call_log_in_ram ;
> QUERY
> PLAN
>
> --
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
EXPLAIN ANALYZE SELECT count(*) from call_log_in_ram ;
QUERY
PLAN
--
Aggregate (cost=90760.80..90760.80 rows=
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
>
>
>
> 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
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
>
> 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
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
10 matches
Mail list logo