On Sat, 17 Jan 2004, Ceri Storey wrote:
> On Fri, Jan 16, 2004 at 10:17:50AM -0800, Stephan Szabo wrote:
> > As a starting point, we're likely to need the exact query, explain analyze
> > output for the query and version information.
>
> Okay, from top to bottom:
>
> SELECT p1.chan_name, p1.prog
We use a server at work that is patched RH 7.3 / 2.4.18 with 2.4.21 (or
thereabouts its < .24).
We have stability issues with Java 1.4 / Tomcat 4.1 but not Pg.
It might even be worth building yourself a vanilla 2.4.18 kernel and
seeing if that makes any difference...
regards
Mark
Josh Berkus
Mark,
> Along similar lines - have generally obtained better server performance
> (and stability) from most Linux distros after replacing their supplied
> kernel with one from kernel.org .
Hmmm any anecdotes about replacing Red Hat 2.4.18 to .24? I've been
having problems I can't track do
Along similar lines - have generally obtained better server performance
(and stability) from most Linux distros after replacing their supplied
kernel with one from kernel.org .
regards
Mark
Josh Berkus wrote:
Folks,
While debugging a wireless card, I came across this interesting bit:
http://
Folks,
While debugging a wireless card, I came across this interesting bit:
http://portal.suse.com/sdb/en/2003/10/pohletz_desktop_90.html
What it indicates is that by default SuSE 9.0 plays with the timeslice values
for the Linux kernel in order to provide a "smoother" user experience. In
my
"Jeremy M. Guthrie" <[EMAIL PROTECTED]> writes:
> With PostGreSQL V7.3.4, a completely reindexed and vacuumed(not-full) foot
> print was 5.2 gig. Now some of the disk space(probably 10-15 % was waiting
> in the FSM to be used). However, 7.4 comes up at 2.3 gig.
First thought is that your 7.3
On Wed, 14 Jan 2004, Ceri Storey wrote:
> Hi there.
>
> I've got a database (the schema is:
> http://compsoc.man.ac.uk/~cez/2004/01/14/tv-schema.sql) for television
> data. Now, one of the things I want to use this for is a now and next
> display. (much like http://teletext.com/tvplus/nownext.asp
On Wed, 14 Jan 2004, CoL wrote:
[plan1]
> -> Seq Scan on menutable b (cost=0.00..13.01 rows=38 width=22)
> (actual time=0.02..0.38 rows=38 loops=1)
[plan2]
> -> Index Scan using menutable_pkey on menutable b
> (cost=0.00..29.36 rows=38 width=22) (actual time=0.02..0.12 rows=38 loops=1)
On Fri, 16 Jan 2004, Anjan Dave wrote:
> 68 processes: 67 sleeping, 1 running, 0 zombie, 0 stopped
> CPU0 states: 3.1% user 4.4% system0.0% nice 0.0% iowait 92.0%
> idle
> CPU1 states: 0.0% user 3.2% system0.0% nice 0.0% iowait 96.3%
> idle
> CPU2 states: 0.4% user 0.3% s
> I'd appreciate if anyone could share your experience
> in configuring things on the filer for optimal
> performance or any recomendataion that i should be
> aware of.
Netapps are great things. Just beware that you'll be using NFS, and NFS
drivers on many operating systems have been known to be
--On Monday, January 12, 2004 13:45:45 -0800 Shankar K <[EMAIL PROTECTED]>
wrote:
Hi There,
We are considering to use NetApp filer for a highly
busy 24*7 postgres database and the reason we chose
netapp, mostly being the "snapshot" functionality for
backing up database online. The filer would
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I recently upgraded from 7.3.4 to 7.4. Besides the PostGreSQL change I
updated my schema to pull out all OIDs and 'set storage external'.
With PostGreSQL V7.3.4, a completely reindexed and vacuumed(not-full) foot
print was 5.2 gig. Now some of t
Hi,
David Shadovitz wrote, On 1/11/2004 7:10 PM:
I understand that COUNT queries are expensive. So I'm looking for advice on
displaying paginated query results.
I display my query results like this:
Displaying 1 to 50 of 2905.
1-50 | 51-100 | 101-150 | etc.
I do this by executing two quer
Hi, I have to following select:
set enable_seqscan = on;
set enable_indexscan =on;
select a.levelno,a.id from (select 1 as levelno,42 as id) a, menutable b
where b.site_id='21' and a.id=b.id;
menutable:
id bigint,
site_id bigint
Indexes: menutable_pkey primary key btree (site_id, id),
The expl
I am writing a website that will probably have some traffic.
Right now I wrap every .php page in pg_connect() and pg_close().
Then I read somewhere that Postgres only supports 100 simultaneous
connections (default). Is that a limitation? Should I use some other
method when writing code for high-t
Hi there.
I've got a database (the schema is:
http://compsoc.man.ac.uk/~cez/2004/01/14/tv-schema.sql) for television
data. Now, one of the things I want to use this for is a now and next
display. (much like http://teletext.com/tvplus/nownext.asp ).
I've got a view defined like this:
CREATE VIEW
Hi There,
We are considering to use NetApp filer for a highly
busy 24*7 postgres database and the reason we chose
netapp, mostly being the "snapshot" functionality for
backing up database online. The filer would be mounted
on a rh linux server (7.3), 4g RAM, dual cpu with a
dedicated card for file
Sorry I wasn't clear. We do have nightly vacuum crons defined on all pg
servers. Apparently, this one had been taking many hours to finish
recently, and we did an additional vacuum during day time when there was
low volume, which finished quickly.
The platform I mentioned is RedHat 9, PG7.4, on De
> Exists in pg any way to define the trigger execution only if I have
> changes on some fields?
No, but you chould check for those fields and return if no changes have been
made. Depending on how intensive the trigger is, this might help. You may
also want to look at statement-level triggers or
19 matches
Mail list logo