Hi all,
Thanks for the reply. I made some more test and find out that the
problem is with the <<= operator for the network type. Can I create
index which to work with <<=. Because if I use = the index is used. But
not for <<=.
iplog=# explain analyze SELECT *
iplog-#
On Fri, 09 Dec 2005 09:15:25 -0500
"Jeremy Haile" <[EMAIL PROTECTED]> wrote:
> > one other note, you probably don't want to use all the disks in a
> > raid10 array, you probably want to split a pair of them off into a
> > seperate raid1 array and put your WAL on it.
>
> Is a RAID 1 array of two
Frank Wiles wrote:
I agree, the extra spindles and lower seek times are better if all
you are concerned about is raw speed.
However, that has to be balanced, from an overall perspective, with
the nice single point of ordering/contact/support/warranty of the
one vendor. It's a tou
On Thu, 08 Dec 2005 11:50:33 -0600
Scott Marlowe <[EMAIL PROTECTED]> wrote:
> Power consumption isn't much differnt, about a watt more for the 15ks,
> so that's no big deal. I'd do a bit of googling to see if there are a
> lot more horror stories with 15k drives than with the 10k ones.
Just an
On Thu, 8 Dec 2005 17:03:27 -
"Dave Page" wrote:
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of
> > Vivek Khera
>
> > I have a choice to make on a RAID enclosure:
> >
> > 14x 36GB 15kRPM ultra 320 SCSI drives
> >
> > OR
> >
> > 12x 7
On Dec 8, 2005, at 5:01 PM, Amit V Shah wrote:
Hi,
The thing is, although it shows 0.15 seconds, when I run the actual
query,
it takes around 40-45 seconds (sorry I forgot to mention that). And
then
sometimes it depends on data. Some parameters have very less number of
records, and others
On 12/9/05, Kaloyan Iliev <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I have a problem with a query which doeson't want to use indexes. I
> tried to create different indexes but nothing help. Can anyone suggest
> what index I need.
> This query is executed 1.5Milion times per day and I need it to be v
> one other note, you probably don't want to use all the disks in a raid10
> array, you probably want to split a pair of them off into a seperate
> raid1 array and put your WAL on it.
Is a RAID 1 array of two disks sufficient for WAL? What's a typical
setup for a high performance PostgreSQL ins
Hi all,
I have a problem with a query which doeson't want to use indexes. I
tried to create different indexes but nothing help. Can anyone suggest
what index I need.
This query is executed 1.5Milion times per day and I need it to be veri
fast. I made my test on 8.0.0 beta but the production da
