ike a perfact candidate for Slony-I
http://www.slony.info . Using Slony-I I see about a 5-7% performance hit in
terms of the number of insert.update/delete per second i can process.
Depending on your network connection , DML volume, and the power of your
backup server, the replica could b
ames)
> for larger queries.
The over head to load the index, fetch the record in there, then check the
table for visibility and return the value, is far greater than just doing 15
compares in the original table.
>
>
> thx
--
Darcy Buskermolen
Wavefire Technologies Corp.
http://www
!
> What is wrong here (because I hope that something is wrong) ?
> Thanks a lot for your help !
>
> Regards
> --
> Arnaud
>
>
> ---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>c
: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to [EMAIL PROTECTED] so that your
>message can get through to the mailing list cleanly
--
Darcy Buskermolen
Command Prompt, Inc.
Sales/Support: +1.503.667.4564 || 24x7/Em
g/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to
"[EMAIL PROTECTED]"
-------
--
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx: 250.763.1759
http://www.wavefire.com
ailman/listinfo/freebsd-performance
To unsubscribe, send any mail to
"[EMAIL PROTECTED]"
---
--
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx: 250.763.1759
http://www.wavefire.com
---(end
---(end of broadcast)---
> TIP 7: don't forget to increase your free space map settings
--
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx: 250.763.1759
http://www.wavefire.com
---(end of broadcast)---
l with out needing to initdb, do you want
to be able to replicate across versions; do you require sync or will async
work, etc..
>
>
>
> Thanks again,
>
> Saranya
>
>
> -
> Do you Yahoo!?
> Read only the mail you want - Yahoo! Mail
limitation of a box size quickly I thing a 4
> >> processors with 64 Gb of RAM ... and after ?
>
> Opteron.
IBM Z-series, or other big iron.
>
> >Go to non-x86 hardware after if you're going to continue to increase the
> >size of the server. Personally I think your better bet might be to
> >figure out a way to partition up your data (isn't that what google
> >does anyway?).
> >
> > Stephen
--
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx: 250.763.1759
http://www.wavefire.com
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
onsider would be pgmemcache. that way you just build the
farm out of lots of large memory, diskless boxes for keeping the whole
database in memory in the whole cluster. More information on it can be found
at: http://people.freebsd.org/~seanc/pgmemcache/
>
> Chris
>
> --
On January 20, 2005 10:42 am, Mitch Pirtle wrote:
> On Thu, 20 Jan 2005 09:33:42 -0800, Darcy Buskermolen
>
> <[EMAIL PROTECTED]> wrote:
> > Another Option to consider would be pgmemcache. that way you just build
> > the farm out of lots of large memory, diskless boxe
me months back, and neilc
was/is/did looking into it. I belive he came up with a way to move the
function call outside of the loop with no ill effects to the rest of the
expected behavior.
>
> regards, tom lane
>
> ---(end of broadcas
Sort Key: dob
> -> Seq Scan on userprofile (cost=0.00..2514.28 rows=178
> width=67) (
> actual time=0.37..1014.50 rows=1783 loops=1)
>Filter: (gender_v AND (gender = 'm'::character varying) AND
> count
> ry_v AND (country = 'br&#
Sort Key: dob
> -> Seq Scan on userprofile (cost=0.00..2514.28 rows=178
> width=67) (
> actual time=0.37..1014.50 rows=1783 loops=1)
>Filter: (gender_v AND (gender = 'm'::character varying) AND
> count
> ry_v AND (country = 'br
olers, different blocksize, ect.
On Tuesday 26 August 2003 11:41, Jeff wrote:
> On Tue, 26 Aug 2003, Darcy Buskermolen wrote:
> > Also, after having taken another look at this, you aren't preforming the
> > same query on both datasets, so you can't expect them to generate the
15 matches
Mail list logo
