On 4 May 2012 17:39, Tom Lane wrote:
> I get a reasonable-looking plan when I try to duplicate this issue in
> 9.1 branch tip. I think the reason you're not getting the right
> behavior is that you are missing this as-yet-unreleased patch:
> http://git.postgresql.org/gitweb/?p=postgresql.git&a=co
Hi,
I'm seeing poor query performance using partitioned tables with check
constraints, seems like the plan is much worse than when querying the
individual partitions manually.
select version(); --> PostgreSQL 9.1.1 on x86_64-unknown-linux-gnu,
compiled by gcc (Debian 4.4.5-8) 4.4.5, 64-bit
uname
Just thought i'd mention that on top of optimising postgres as much as
possible, don't forget how much something like memcached can do for you
http://www.danga.com/memcached/
we use it on www.last.fm - most pages only take one or two database hits,
compared with 30 to 40 when memcache is turned
Hi, i'm on the verge of buying a "MegaRAID SCSI 320-2" raid controller.
I need it to build a db server using 4x ultra320 scsi disks
i'm thinking raid 1+0 but will try with raid5 too and compare
Does anyone have any experience with this model, good or bad i'd like to
know.. thanks :)
as seen:
htt
get rid of any unnecessary indexes?
i've found that droping indexes and re-creating them isn't usually worth the
effort
mount the disk with the noatime option which saves you the time involved in
updating the last access time on files
make sure you're doing all the inserts in one transaction..
The dual xeon arrangement is because the machine will also have to do some
collaborative filtering which is very cpu intensive and very disk
un-intensive, after loading the data into ram.
On Friday 12 September 2003 5:49 pm, you wrote:
> RIchard,
>
> > its a dual xeon 2.4, 4gb ram and 3x identi
raid controller separately,
which appeals to me but i wouldnt know what to look for in a raid controller.
that raid controller review site sounds like a good idea :)
Richard.
On Friday 12 September 2003 4:24 pm, Christopher Browne wrote:
> [EMAIL PROTECTED] (Richard Jones) writes:
> > I
Hi all,
I have some new hardware on the way and would like some advice on how to get
the most out of it..
its a dual xeon 2.4, 4gb ram and 3x identical 15k rpm scsi disks
should i mirror 2 of the disks for postgres data, and use the 3rd disk for the
o/s and the pg logs or raid5 the 3 disks or
On Saturday 30 August 2003 1:08 pm, you wrote:
> On Sat, 30 Aug 2003, Richard Jones wrote:
> > Hi,
> > i have a table of around 3 million rows from which i regularly (twice a
> > second at the moment) need to select a random row from
> >
> > currently i'm d
Hi,
i have a table of around 3 million rows from which i regularly (twice a second
at the moment) need to select a random row from
currently i'm doing "order by rand() limit 1" - but i suspect this is
responsible for the large load on my db server - i guess that PG is doing far
too much work ju
10 matches
Mail list logo
