Oleg,
Le Mercredi 17 Novembre 2004 18:23, Oleg Bartunov a écrit :
Sorry but when I do your request I get :
# select id_site from site where idx_site_name @@ 'livejourn';
ERROR: type does not exist
no idea :) btw, what version of postgresql and OS you're running.
Could you try minimal
Have you run 'vacuum analyze' ?
1;2c1;2c1;2c
1;2c1;2c1;2cmy desktop is very simple PIII, 512 Mb RAM.
1;2c1;2c1;2cOleg
1;2c1;2c1;2c
1;2c1;2c1;2cOn Thu, 18 Nov 2004, [iso-8859-15] Herv? Piedvache wrote:
Oleg,
Le Mercredi 17 Novembre 2004 18:23, Oleg Bartunov a ?crit :
Sorry but when I do your
Le Jeudi 18 Novembre 2004 10:37, Oleg Bartunov a écrit :
Have you run 'vacuum analyze' ?
Yep every night VACUUM FULL VERBOSE ANALYZE; of all the database !
1;2c1;2c1;2c
1;2c1;2c1;2cmy desktop is very simple PIII, 512 Mb RAM.
1;2c1;2c1;2c Oleg
1;2c1;2c1;2c
YOU send strange caracters ! ;o)
1;2c1;2c1;2cBlin !
what's happenning with my terminal when I read messagess from this guy ?
I don't even know how to call him - I see just Herv?
Oleg
1;2c1;2c1;2c1;2c
1;2cOn Thu, 18 Nov 2004, [iso-8859-15] Herv? Piedvache wrote:
Le Jeudi 18 Novembre 2004 10:37, Oleg Bartunov a ?crit :
Have
Hello All,
I have a setup with a Dell Poweredge 2650 with Red Hat and Postgres 7.4.5 with
a database with about 27GB of data. The table in question has about 35 million
rows.
I am running the following query:
SELECT *
FROM mb_fix_message
WHERE msg_client_order_id IN (
SELECT
Andrew,
It seems that you could combine the subquery's WHERE clause with the main
query's to produce a simpler query, i.e. one without a subquery.
Rick
Actually, unfortunately, that won't work. The subquery gets a list of message
IDs and then the outer query gets the responses to those messages.
Also, I dumped this data and imported it all to ms sql server and then ran it
there. The query ran in 2s.
Andrew
-Original Message-
From:
Andrew,
What version of Redhat are you running? We have found running Enterprise
Update 3 kernel kills our Dell boxes with IOWait, both NFS and local disk
traffic. Update 2 kernel does not seem to have the issue, and we are in the
process of trying Update 4 beta to see if it is better.
I have run ANALYZE right before running this query.
I will run EXPLAIN ANALYZE when I can. I started running the query when I sent
the first email and it is still running. Looke like it longer than an hour.
I will post the results of EXPLAIN ANALYZE in a few hours when I get them.
Thanks for
What I think is happening with the missing pg_statistic entries:
The install of our application involves a lot of data importing (via
JDBC) in one large transaction, which can take up to 30 minutes. (I
realize I left out this key piece of info in my original post...)
The pg_autovacuum logic is
Hello,
What is your statistics target?
What is your effective_cache_size?
Have you tried running the query as a cursor?
Sincerely,
Joshua D. Drake
Andrew Janian wrote:
I have run ANALYZE right before running this query.
I will run EXPLAIN ANALYZE when I can. I started running the query when I
Can someone explain how the free space map deals with alternate database
locations?
Given that the free space map is global, and it is ostensibly managing
free disk space, how does it deal with tuples across disk locations ?
Dave
--
Dave Cramer
http://www.postgresintl.com
519 939 0336
Andrew,
Dell's aren't well known for their disk performance, apparently most of
the perc controllers sold with dell's are actually adaptec controllers.
Also apparently they do not come with the battery required to use the
battery backed up write cache ( In fact according to some Dell won't
Dave,
Given that the free space map is global, and it is ostensibly managing
free disk space, how does it deal with tuples across disk locations ?
Are you talking Tablespaces?
--
Josh Berkus
Aglio Database Solutions
San Francisco
---(end of
Woody,
What version of Redhat are you running? We have found running Enterprise
Update 3 kernel kills our Dell boxes with IOWait, both NFS and local disk
traffic. Update 2 kernel does not seem to have the issue, and we are in
the process of trying Update 4 beta to see if it is better.
Dave Cramer [EMAIL PROTECTED] writes:
Can someone explain how the free space map deals with alternate database
locations?
It doesn't really care. It identifies tables by database OID+table OID,
and where they happen to sit physically doesn't matter.
regards, tom lane
No, have a look at the create database command
there is a clause 'with location' that allows you to set up a separate
location for the db
Dave
Josh Berkus wrote:
Dave,
Given that the free space map is global, and it is ostensibly managing
free disk space, how does it deal with
From our experience it is not just a postgres issue, but all IO with the
Update 3 kernel.
We have a box with Update 3 that queries a remote postgres database(Running
RH7.3, RH3 Update2) and writes to a file on an NFS server. The update 3
box does half the work with 2-3 times the load as our
Ok, so the global part of the fsm is just that it is in shared memory.
If certain databases have more
free space they will simply take up more of the fsm. There is no cross
database movement of tuples.
( I realized this when I tried to form my next question)
Dave
Tom Lane wrote:
Dave
So What does memcached offer pgsql users? It would still seem to offer
the benefit of a multi-machined cache.
Ack, I totally missed this thread. Sorry for jumping in late.
Basically, memcached and pgmemcache offer a more technically correct
way of implementing query caching. MySQL's query
20 matches
Mail list logo