Hasnul,
> My question is if there is a query design that would query multiple
> server simultaneously.. would that improve the performance?
Not without a vast amounts of infrastructure coding. You're basically
talking about what Oracle has spent the last 3 years and $100 million working
on.
Spiegelberg, Greg wrote:
My experience with dblink() is that each dblink() is executed serially
Correct.
If you really want to do multiple queries simultaneously, you would need
to write a function very similar to dblink_record, but using asynchonous
libpq calls to both remote hosts. See:
http:
Hello,
My experience with dblink() is that each dblink() is executed serially, in
part I would guess, due to the plan for the query. To have each query run
in parallel you would need to execute both dblink()'s simultaneously saving
each result into a table. I'm not sure if the same table could b
On Mon, Dec 13, 2004 at 17:32:02 -0200,
Alvaro Nunes Melo <[EMAIL PROTECTED]> wrote:
> Em Seg, 2004-12-13 às 16:03, Bruno Wolff III escreveu:
> > On Mon, Dec 13, 2004 at 15:17:49 -0200,
> > Alvaro Nunes Melo <[EMAIL PROTECTED]> wrote:
> > > db=> SELECT COUNT(*) FROM titulo WHERE cd_pessoa = 1;
Hi,
(B
(BSorry, I didn't catch the original message, so I'm not sure if the original
(Bposter mentioned the postgres version that he's using.
(B
(BI just thought that I'd contribute this observation.
(B
(BI have a DB that takes several hours to restore under 7,1 but completes in
(Baround
Hi,
I am not sure if this is the place to ask this question, but since the
question is trying to improve the performance.. i guess i am not that
far off.
My question is if there is a query design that would query multiple
server simultaneously.. would that improve the performance?
To make it c
Hi All,
I have a question regarding multiple inserts.
The following function inserts for each country found in country table, values into merchant_buyer_country.
> "JB" == Josh Berkus <[EMAIL PROTECTED]> writes:
>> FYI ... the 750s, 1850s and 2850s use Intel chipsets (E7520 on 1850s
>> and 2850s, 7210 on 750s), Intel NICs, and come only with LSI Logic
>> RAID controllers. It looks like Dell has dropped the
>> Broadcom/ServerWorks and Adaptec junk.
J
However, I keep getting conflicting advice. My choices are along
these lines:
Dual Xeon 64bit with built-in 6-disk RAID10 or RAID5 (LSI RAID card)
Dual Opteron 64bit with built-in 6-disk RAID10 or RAID5 (LSI RAID card)
Dual Opteron 64bit with external RAID via fibre channel (eg, nstor)
An Opteron
Sven Willenberger <[EMAIL PROTECTED]> writes:
> explain analyze select storelocation,order_number from custacct where
> referrer = 1365 and orderdate between '2004-12-07' and '2004-12-07
> 12:00:00' order by custacctid limit 10;
> QUERY PLAN
> --
Andrew McMillan wrote:
On Mon, 2004-12-13 at 01:13 -0500, Sven Willenberger wrote:
I have a question regarding a serious performance hit taken when using a
LIMIT clause. I am using version 7.4.6 on FreeBSD 4.10-STABLE with 2GB
of memory. The table in question contains some 25 million rows with a
Vivek,
> Do I need a correspondingly large checkpoint timeout then? Or does
> that matter much?
Yes, you do.
> And does this advice apply if the pg_xlog is on the same RAID partition
> (mine currently is not, but perhaps will be in the future)
Not as much, but it's still a good idea to seriali
Em Seg, 2004-12-13 às 16:03, Bruno Wolff III escreveu:
> On Mon, Dec 13, 2004 at 15:17:49 -0200,
> Alvaro Nunes Melo <[EMAIL PROTECTED]> wrote:
> > db=> SELECT COUNT(*) FROM titulo WHERE cd_pessoa = 1;
> > count
> > ---
> >220
> > (1 record)
> >
> > Time: 48,762 ms
> > db=> SELECT COUN
Josh Berkus <[EMAIL PROTECTED]> writes:
> Not as much, but it's still a good idea to serialize the load. With too few
> segments, you get a pattern like:
> Fill up segments
> Write to database
> Recycle segments
> Fill up segments
> Write to database
> Recycle segments
> etc.
Actually I think
Vivek,
> Dual Xeon 64bit with built-in 6-disk RAID10 or RAID5 (LSI RAID card)
> Dual Opteron 64bit with built-in 6-disk RAID10 or RAID5 (LSI RAID card)
> Dual Opteron 64bit with external RAID via fibre channel (eg, nstor)
Opteron over Xeon, no question.Not only are the Opterons
real-world-fa
Thanks guys!! that worked!:)
Michael Adler <[EMAIL PROTECTED]> wrote:
On Mon, Dec 13, 2004 at 08:28:39AM -0800, sarlav kumar wrote:> INSERT into merchant_buyer_country (merchant_id,country,enabled,group_id) values (1203, > (SELECT code FROM country WHERE send IS NOT NULL OR receive IS NOT NULL),
Vivek,
> The biggest improvement in speed to restore time I have discovered is
> to increase the checkpoint segments. I bump mine to about 50. And
> moving the pg_xlog to a separate physical disk helps a lot there, too.
Don't leave it at 50; if you have the space on your log array, bump it up t
Vivek Khera wrote:
> > "FW" == Frank Wiles <[EMAIL PROTECTED]> writes:
>
> FW> I believe I had expressed some problems with Dell in the past, but
> FW> it really isn't a quality control issue that I have seen. It is more
> FW> of a Linux support issue. Lately I've been running into pro
> "FW" == Frank Wiles <[EMAIL PROTECTED]> writes:
FW> I believe I had expressed some problems with Dell in the past, but
FW> it really isn't a quality control issue that I have seen. It is more
FW> of a Linux support issue. Lately I've been running into problems with
Ditto that experi
On Mon, Dec 13, 2004 at 08:28:39 -0800,
sarlav kumar <[EMAIL PROTECTED]> wrote:
>
> Is there a way to write the INSERT as follows?
>
> INSERT into merchant_buyer_country (merchant_id,country,enabled,group_id)
> values (1203,
> (SELECT code FROM country WHERE send IS NOT NULL OR receive IS N
> "RC" == Rodrigo Carvalhaes <[EMAIL PROTECTED]> writes:
RC> Hi!
RC> I am using PostgreSQL with a proprietary ERP software in Brazil. The
RC> database have around 1.600 tables (each one with +/- 50 columns).
RC> My problem now is the time that takes to restore a dump. My customer
RC> database
> "BS" == Bo Stewart <[EMAIL PROTECTED]> writes:
BS> The servers listed above are the dell 2650's which have perc 3
BS> controllers. I have seen on this list where they are know for not
BS> performing well. So any suggestions for an attached scsi device would
BS> be greatly appreciated. Als
On Mon, 2004-12-13 at 01:13 -0500, Sven Willenberger wrote:
> I have a question regarding a serious performance hit taken when using a
> LIMIT clause. I am using version 7.4.6 on FreeBSD 4.10-STABLE with 2GB
> of memory. The table in question contains some 25 million rows with a
> bigserial prim
23 matches
Mail list logo
