OK I found the cause, it was a default settings added on server start.
(-B 1024) Gr!
Now it works really better I devide the full time per 2.
I suppose I steal have to look deep in the procedure to see some hack,
has somebody suggest, I will try to buffer all updates in one.
One
We have very good experiences with openVZ as virtualizer.
Since it's not a para virtualization like xen it's very fast. Almost
as fast as the host.
www.openvz.org
Am 04.03.2008 um 16:43 schrieb Theo Kramer:
Hi
We are thinking of running a PostgreSQL instance on a virtual host
under
Xen.
Dear Friends,
I have a table with 50 lakhs records, the table has more then 10
fields, i have primary key, i have select query with count(*) without any
condition, it takes 17 seconds.
I have another one query which will do joins with other small tables, it
takes 47 seconds to give output,
DGB87PGD
--
With Best Regards,
Petchimuthulingam S
Hi,
Le mercredi 05 mars 2008 à 11:39 +0100, Steinar H. Gunderson a écrit :
> Without knowing what a "lakhs" record is,
I had the same question... and Wikipedia gave me the answer : it is an
Indian word meaning 10^5, often used in indian english.
Franck
--
Sent via pgsql-performance mailing
On Wed, Mar 05, 2008 at 02:27:08AM -0800, SPMLINGAM wrote:
> I have a table with 50 lakhs records, the table has more then 10
> fields, i have primary key, i have select query with count(*) without any
> condition, it takes 17 seconds.
Without knowing what a "lakhs" record is, it's pretty obv
> > Without knowing what a "lakhs" record is,
>
> I had the same question... and Wikipedia gave me the answer : it is an
> Indian word meaning 10^5, often used in indian english.
Thank you (both OP and this post) for enlightening us with this word.
--
regards
Claus
When lenity and cruelty pl
Hi,
I've run it on xen. works OK. Course this is all predicated upon your
expectations. If you expect it to be as fast as a dedicated machine,
you will be dissapointed.
Dave
On 5-Mar-08, at 3:54 AM, Moritz Onken wrote:
We have very good experiences with openVZ as virtualizer.
Since it's n
Hello,
We had a bad experience with PostgreSQL running in OpenVZ (year and a
half year ago): OpenVZ kernel killed postmaster with strange signals
from time to time, failcounters of OpenVZ did not worked as expected
in this moments, PostgreSQL fighted for the disk with applications in
other virtual
In response to "Ivan Zolotukhin" <[EMAIL PROTECTED]>:
>
> We had a bad experience with PostgreSQL running in OpenVZ (year and a
> half year ago): OpenVZ kernel killed postmaster with strange signals
> from time to time, failcounters of OpenVZ did not worked as expected
> in this moments, PostgreSQ
Hello,
On Wed, Mar 5, 2008 at 5:40 PM, Bill Moran
<[EMAIL PROTECTED]> wrote:
> In response to "Ivan Zolotukhin" <[EMAIL PROTECTED]>:
>
> >
> > We had a bad experience with PostgreSQL running in OpenVZ (year and a
> > half year ago): OpenVZ kernel killed postmaster with strange signals
> > from
> -Original Message-
> From: SPMLINGAM
> Subject: [PERFORM] postgresql performance
>
> Dear Friends,
> I have a table with 50 lakhs records, the table has more
> then 10 fields, i have primary key, i have select query with
> count(*) without any condition, it takes 17 seconds.
17 s
>>> On Wed, Mar 5, 2008 at 4:39 AM, in message <[EMAIL PROTECTED]>,
"Steinar H. Gunderson" <[EMAIL PROTECTED]> wrote:
> it's pretty obvious that you
> haven't vacuumed in a very long time. Run VACUUM FULL on your tables
If you use VACUUM FULL, you should probably throw in ANALYZE with
it, and
In response to "Dave Dutcher" <[EMAIL PROTECTED]>:
> > -Original Message-
> > From: SPMLINGAM
> > Subject: [PERFORM] postgresql performance
> >
> > Dear Friends,
> > I have a table with 50 lakhs records, the table has more
> > then 10 fields, i have primary key, i have select query
Below I have two almost identical queries. Strangely enough the one
that uses the index is slower ???
explain analyze select uid from user_profile where
lower(firstname)='angie' and extract(year from age('2008-02-26
02:50:31.382', dob)) >= 18 and extract(year from age('2008-02-26
02:50:3
OI6PQO5P
--
With Best Regards,
Petchimuthulingam S
R9PKE431
--
With Best Regards,
Petchimuthulingam S
HZ5DHKQJ
--
With Best Regards,
Petchimuthulingam S
C5BK4513
--
With Best Regards,
Petchimuthulingam S
petchimuthu lingam wrote:
C5BK4513
Ahh - you are sending this to the wrong address, these are not being
sent by the postgres mailing list.
Check which address you are replying to next time...
--
Postgresql & php tutorials
http://www.designmagick.com/
--
Sent via pgsql-performance mailing l
sathiya psql wrote:
count(*) tooks much time...
but with the where clause we can make this to use indexing,... what
where clause we can use??
Am using postgres 7.4 in Debian OS with 1 GB RAM,
am having a table with nearly 50 lakh records,
Looks suspiciously like a question asked yesterday:
P289ZUDZ
--
With Best Regards,
Petchimuthulingam S
count(*) tooks much time...
but with the where clause we can make this to use indexing,... what where
clause we can use??
Am using postgres 7.4 in Debian OS with 1 GB RAM,
am having a table with nearly 50 lakh records,
it has more than 15 columns, i want to count how many records are there, it
am Thu, dem 06.03.2008, um 11:13:01 +0530 mailte sathiya psql folgendes:
> count(*) tooks much time...
>
> but with the where clause we can make this to use indexing,... what where
> clause we can use??
An index without a WHERE can't help to avoid a seq. scan.
>
> Am using postgres 7.4 in Deb
On Thu, Mar 6, 2008 at 5:08 PM, A. Kretschmer <
[EMAIL PROTECTED]> wrote:>
> > am having a table with nearly 50 lakh records,
> >
> > it has more than 15 columns, i want to count how many records are there,
> it is
> > taking nearly 17 seconds to do that...
> >
> > i know that to get a approximate
buy every time i need to put ANALYZE...
this takes the same time as count(*) takes, what is the use ??
On Thu, Mar 6, 2008 at 11:45 AM, Shoaib Mir <[EMAIL PROTECTED]> wrote:
> On Thu, Mar 6, 2008 at 5:08 PM, A. Kretschmer <
> [EMAIL PROTECTED]> wrote:>
>
> > > am having a table with nearly 50 lak
On Thu, Mar 6, 2008 at 5:19 PM, sathiya psql <[EMAIL PROTECTED]> wrote:
> buy every time i need to put ANALYZE...
> this takes the same time as count(*) takes, what is the use ??
>
>
>
Dont you have autovacuuming running in the background which is taking care
of the analyze as well?
If not then h
There aren't a general solution. If you realy need the exact count of
tuples than you can play with a TRIGGER and increase/decrease the
tuple-count for this table in an extra table.
Of course, this means accepting the cost of obtaining update locks on
the count table.
The orig
hi,
is there any generalized format for the output for the output of the
explain command ?. If so please send that generalized format to me.
otherwise tell me how to parse the output of explain command to
know where the relation name occurs,where the conditions occurs,
where the join conditio
will you please tell, what is autovacuuming... and wat it ll do... is there
any good article in this
On Thu, Mar 6, 2008 at 11:56 AM, Shoaib Mir <[EMAIL PROTECTED]> wrote:
> On Thu, Mar 6, 2008 at 5:19 PM, sathiya psql <[EMAIL PROTECTED]>
> wrote:
>
> > buy every time i need to put ANALYZE...
On Thu, Mar 6, 2008 at 5:31 PM, sathiya psql <[EMAIL PROTECTED]> wrote:
> will you please tell, what is autovacuuming... and wat it ll do... is
> there any good article in this
>
>
>
Read this -->
http://www.postgresql.org/docs/8.3/interactive/routine-vacuuming.html#AUTOVACUUM
--
Shoaib Mir
is there any way to explicitly force the postgres to use index scan
On Thu, Mar 6, 2008 at 12:06 PM, A. Kretschmer <
[EMAIL PROTECTED]> wrote:
> am Thu, dem 06.03.2008, um 1:26:46 -0500 mailte Mark Mielke folgendes:
> >
> >
> > There aren't a general solution. If you realy need the exac
-- Forwarded message --
From: sathiya psql <[EMAIL PROTECTED]>
Date: Thu, Mar 6, 2008 at 12:17 PM
Subject: Re: [PERFORM] count * performance issue
To: "A. Kretschmer" <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED]
TRIGGER i can use if i want the count of the whole table, but i require
am Thu, dem 06.03.2008, um 12:13:17 +0530 mailte sathiya psql folgendes:
> is there any way to explicitly force the postgres to use index scan
Not realy, PG use a cost-based optimizer and use an INDEX if it make
sense.
>
> On Thu, Mar 6, 2008 at 12:06 PM, A. Kretschmer <
> [EMAIL PROTECTED]> w
am Thu, dem 06.03.2008, um 12:17:55 +0530 mailte sathiya psql folgendes:
> TRIGGER i can use if i want the count of the whole table, but i require for
> some of the rows with WHERE condition
>
> so how to do that ???
Okay, in this case a TRIGGER are a bad idea. You can use an INDEX on
this r
am Thu, dem 06.03.2008, um 1:26:46 -0500 mailte Mark Mielke folgendes:
>
>
> There aren't a general solution. If you realy need the exact count of
> tuples than you can play with a TRIGGER and increase/decrease the
> tuple-count for this table in an extra table.
>
>
>
QUERY PLAN
--
Aggregate (cost=205756.95..205756.95 rows=1 width=0) (actual time=
114675.042..114675.042 rows=1 loop
On Thu, 6 Mar 2008 12:32:01 +0530
"sathiya psql" <[EMAIL PROTECTED]> wrote:
> i had a table with 50 lakh record...
>
> it has a column called oid ( obviously all the tables will have
> this ), but while doing any operation it is getting slow because of
> the number of records...
Actually it isn'
am Thu, dem 06.03.2008, um 12:36:48 +0530 mailte sathiya psql folgendes:
>
> QUERY PLAN
> --
> Aggregate (cost=20
On Thu, 2008-03-06 at 12:32 +0530, sathiya psql wrote:
> i had a table with 50 lakh record...
>
> it has a column called oid ( obviously all the tables will have
> this ), but while doing any operation it is getting slow because of
> the number of records...
>
> if i remove the oid column will i
>
> Actually it isn't obvious as oids have been deprecated for years.
no in my version it is now also available
>
>
> What version of ancient PostgreSQL are you running exactly?
postgresql 7.4
i had a table with 50 lakh record...
it has a column called oid ( obviously all the tables will have this ), but
while doing any operation it is getting slow because of the number of
records...
if i remove the oid column will i get any benefit, what are all the other
default columns created witho
42 matches
Mail list logo
