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 cachin
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 Cra
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 upda
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
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 la
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,
> 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 broadcast)---
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
even
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
ICQ#14675
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 sen
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 re
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
"Andrew Janian" <[EMAIL PROTECTED]> writes:
>
>
>
>
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.
Woody
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,
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
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 msg_clien
French encodings vs. Cyrillic encodings? Characters coming thru the mail in
some encoding that don't get translated properly.
His name is Herve Piedvache, where the 2nd 'e' in Herve is an accented
character. It must somehow do weird things to your terminal when it's trying to
map that into the
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
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 ! ;
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 req
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 t
22 matches
Mail list logo