Andrew Smith wrote:
> - C++ app reads data from proprietary system and writes it into temp
> table in PostgreSQL
> - ASP.NET web service reads data from temp table in PostgreSQL and
> generates HTML
[snip]
> This temp table will probably contain up to 1 records, each of
> which could be changi
Greg Stark wrote:
> Actually most of the estimates seem pretty good. There are some that
> are a ways off, but the real nasties seem to be these. I'm a bit
> confused because it looks like two of your joins don't have Join
> Filters -- and one of those is a left join for which I thought that
> was
On Wed, Jun 24, 2009 at 12:48 AM, Scott Marlowe wrote:
> Maybe. Rows that are updated often are NOT generally pgsql's strong
> suit, but IF you're running 8.3 or above, and IF you have a low enough
> fill factor that there's empty space for the updates and IF the fields
> you are updating are not
On Tue, Jun 23, 2009 at 10:12 PM, Andrew Smith wrote:
> This temp table will probably contain up to 1 records, each of
> which could be changing every second (data is coming from a real-time
> monitoring system). On top of this, I've then got the ASP.NET app
> reading the updated data values
Hi all,
I'm working on a problem at the moment where I have some data that I
need to get from a proprietary system into a web page. I was thinking
of using PostgreSQL as a middle man to store the data. E.g
- C++ app reads data from proprietary system and writes it into temp
table in PostgreSQL
The PostgreSQL Conference, U.S. series is having a PgDay on Saturday,
September 19, 2009 at The University of Georgia in Athens, GA, less
than 90 minutes from Atlanta. PgDay will be a single-day event located in
historic Old College on the University's beautiful North Campus.
Recently named number
On Tue, Jun 23, 2009 at 10:07 PM, Craig Ringer
wrote:
> Thomas Kellerer wrote:
> > Mike Christensen wrote on 23.06.2009 19:37:
> >> Does anyone actually have that (any node can go down and the others
> still
> >> replicate amongst themselves?)
> >
> > I think this is what Oracle promises with thei
Radcon Entec wrote:
> I like to use RAISE NOTICE statements to make sure my functions are working
> correctly. I just wrote a trigger function that has the following code:
[snip]
> I am trying to insert a carriage return character (chr(10)) in the user name
> notice so that any subsequent noti
Thomas Kellerer wrote:
> Mike Christensen wrote on 23.06.2009 19:37:
>> Does anyone actually have that (any node can go down and the others still
>> replicate amongst themselves?)
>
> I think this is what Oracle promises with their RAC technology.
Isn't RAC a shared-storage cluster?
--
Craig Rin
On Tuesday 23 June 2009, Radcon Entec wrote:
> Greetings!
>
> At the current moment, our customer's computer has 22 instances of
> postgres.exe running. When a colleague checked a few minutes ago, there
> were 29. Our contract specifies that we cannot consume more than 40% of
> the computer's me
> In response to Radcon Entec :
>> At the current moment, our customer's computer has 22 instances of
>> postgres.exe running. When a colleague checked a few minutes ago, there
>> were 29. Our contract specifies that we cannot consume more than 40% of the
>> computer's memory, and we're over t
2009/6/23 Radcon Entec
> Greetings!
>
> At the current moment, our customer's computer has 22 instances of
> postgres.exe running. When a colleague checked a few minutes ago, there
> were 29. Our contract specifies that we cannot consume more than 40% of the
> computer's memory, and we're over
Jack Orenstein wrote:
If x is an integer column with an index, then
select ...
from T
where x > 1
and
select ...
from T
where x > 10
could be optimized differently. So how is optimization done for a
prepared statement containing a variable, e.g.
select .
It worked, Thaks!!!
On Wed, Jun 24, 2009 at 4:15 AM, Vibhor Kumar wrote:
> "more" exists in C:\Windows\System32. So, please set the path in PATH
> Environment Variable. and then try.
> My Computer (Right Click) -> Properties -> then go to Advanced tab ->
> Environment Variable -> set the pat
"more" exists in C:\Windows\System32. So, please set the path in PATH
Environment Variable. and then try.
My Computer (Right Click) -> Properties -> then go to Advanced tab ->
Environment Variable -> set the path.
Thanks & Regards,
Vibhor Kumar
www.enterprisedb.com
raghu ram wrote:
Hi All,
Hi All,
Can anyone tel me what does this error mean. “ 'more' is not recognized as
an internal or external command, operable program or batch file. “
C:\Program Files\PostgresPlus\8.4\bin>psql -d postgres -p 5456 -U postgres
psql (8.4rc1)
WARNING: Console code page (437) differs from Windows cod
On Tue, 23 Jun 2009 17:39:46 -0300
Emanuel Calvo Franco wrote:
> 2009/6/23 Ivan Sergio Borgonovo :
> > I've a temporary table where I'd like to resume data coming from
> > several other tables (normalised the usual way).
> > eg.
> > a list of items that may belong to several group (eg. item,
> >
In response to Radcon Entec :
> Greetings!
>
> At the current moment, our customer's computer has 22 instances of
> postgres.exe running. When a colleague checked a few minutes ago, there were
> 29. Our contract specifies that we cannot consume more than 40% of the
> computer's memory, and w
>
> select ...
> from T
> where x > $1
>
prepare testy_prepare(int) as select * from T where x = $1;
execute testy_prepare(4);
Follow the docs :)
http://www.postgresql.org/docs/8.1/interactive/sql-prepare.html
--
Emanuel Calvo Franco
ArPUG [www.arpug.com.ar] / AOSUG Mem
Greetings!
At the current moment, our customer's computer has 22 instances of postgres.exe
running. When a colleague checked a few minutes ago, there were 29. Our
contract specifies that we cannot consume more than 40% of the computer's
memory, and we're over that level. When does an instanc
2009/6/23 Ivan Sergio Borgonovo :
> I've a temporary table where I'd like to resume data coming from
> several other tables (normalised the usual way).
> eg.
> a list of items that may belong to several group (eg. item,
> group, itemgroup table) will end up in something similar to:
>
> create temp
If x is an integer column with an index, then
select ...
from T
where x > 1
and
select ...
from T
where x > 10
could be optimized differently. So how is optimization done for a prepared
statement containing a variable, e.g.
select ...
from T
where
I like to use RAISE NOTICE statements to make sure my functions are working
correctly. I just wrote a trigger function that has the following code:
-- We have a new tender. Find out who it is.
select into userRecord * from users where users_key = new.tender_key;
if not found then
r
On Tue, Jun 23, 2009 at 2:05 PM, Gus
Gutoski wrote:
> Success, of sorts. I was able to retrieve 90% the corrupted data by
> dumping the heap file. Many thanks to those who replied with helpful
> suggestions.
>
> If you're interested in detail then read on. Otherwise, don't bother.
>
> The data w
2009/6/23 Greg Sabino Mullane :
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: RIPEMD160
>
>
>> It is true. Otherwise show me a viable replication offering for
>> postgresql that I can put into production and obtain support for it.
>
> It depends on what you mean by "replication", but if you need
--- On Mon, 22/6/09, Gerry Reno wrote:
> Have you ever tried any of the postgresql replication
> offerings? The only one that is remotely viable is slony and
> it is so quirky you may as well forget it. The rest are in
> some stage of decay/abandonment. There is no real
> replication available f
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> It is true. Otherwise show me a viable replication offering for
> postgresql that I can put into production and obtain support for it.
It depends on what you mean by "replication", but if you need
master-master (or even a really good master-
On Tue, Jun 23, 2009 at 01:31:59PM -0400, Merlin Moncure wrote:
> not sure what you mean by entry point? getting it running is a snap
> if you've already ever done a warm standby setup. The hard part will
> be patching it in.
In my case, I'd need to know where the patch can be downloaded and whe
Mike Christensen wrote on 23.06.2009 19:37:
Does anyone actually have that (any node can go down and the others still
replicate amongst themselves?)
I think this is what Oracle promises with their RAC technology.
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
"Philippe Amelant" writes:
> Can I workaround this ?
Don't assume that "1 month" means a constant number of seconds.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/m
>
> Hi Mike
>
> thanks for your interest in rubyrep. I developed rubyrep. Let me
> answer your questions.
>
> On Jun 23, 4:16 pm, m...@kitchenpc.com (Mike Christensen) wrote:
> > There will be a set of triggers for each replication. Since MySql
> doesn't
> > support more than one trigger on a tabl
On Tue, Jun 23, 2009 at 11:01 AM, Ray Stell wrote:
> On Tue, Jun 23, 2009 at 10:24:28AM -0400, Merlin Moncure wrote:
>> If you are
>> adventurous/enterprising, you could dig up the hot standby patch, get
>> it in line with the soon to be released 8.4, and play with it...it
>> works very well.
>
> W
Yes, surely bigserial of overdimensioned.
Anyway, i need to keep the postgresql cpu and ram usage as lower as
possible, same for the disk usage.
I'm starded an application that would be similar to shopify.com, but
free and opensource (it will be opensource just when i'll finish at
least the first
Hi all,
here is a little test case for a problem we run into in our
developpement
Is it a bug or a setting problem ?
try
select (current_timestamp),(current_timestamp - interval '1008 hours');
report this value in age()
select age('2009-06-23 18:36:05.064066+02' ,'"2009-05-12 18:36:05.064066
+
I thought to analyze the input chars to avoid useless searches, for
example, if the digit is EX, where X is number, it is the
user_code, and i'll search just that field; otherwise if the digit is
an email, i'll look only at the email column.
But, the things get little deeper, with the custom f
Thanks! That'll reduce the amount of copy/pasting I have to do to figure
out the differences in times.
Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kingston General Hospital
(613) 549- x4294
-Original Message-
From: Chris Spotts [mailto:rfu...@gmail.com]
Sent: T
2009/6/23 Devrim GÜNDÜZ :
> On Mon, 2009-06-22 at 18:28 -0400, Gerry Reno wrote:
>> The only one that is remotely viable is slony and it is so quirky you
>> may as well forget it.
>
> Like what? I agree that Slony-I is not a plug-in-play replication
> solution, but I don't agree that it is so quirk
On Mon, Jun 22, 2009 at 9:43 PM, Craig
Ringer wrote:
> On Mon, 2009-06-22 at 21:12 -0600, Scott Marlowe wrote:
>> On Mon, Jun 22, 2009 at 8:59 PM, Craig
>> Ringer wrote:
>>
>> > So ... it doesn't seem likely that statement-level replication would
>> > ever get far in Pg because of nasty issues like
sergio nogueira writes:
> monitor=# vacuum full
> monitor-# ;
> ERROR: could not truncate relation 18293/18295/19113 to 68908 blocks:
> Permission denied
> PANIC: cannot abort transaction 140578842, it was already committed
The PANIC is a known problem if vacuum full fails at the wrong place.
T
DaNieL wrote:
Hi guys, im tryin to optimize a simple table, suited for contain
users.
So, my table at the moment is:
-
CREATE TABLE contacts(
id BIGSERIAL PRIMARY KEY NOT NULL UNIQUE,
company_id BIGINT,
code varchar(10),
company_name varchar(120),
name varchar(120),
surname varchar(120
IMHO running queries on 23k'ish worth of rows isn't liable to stress any
reasonably modern server, likely several times over that shouldn't either
for simple "LIKE" searches.
What kind of growth are you expecting?
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsq
Yes, after my post i've tryed the versione with 2 separate table (a
copy of the contact table) with inside just the employees, and, with
my surprise, the query planner looks identical, both with 1 big table
and with 2 splitted table.
This sound a bit strange for me, becose in my test the 'employees
On Tue, Jun 23, 2009 at 2:00 PM, Dave Page wrote:
> On Tue, Jun 23, 2009 at 1:38 PM, David Fetter wrote:
>> On Tue, Jun 23, 2009 at 03:38:35PM +0800, Prasad, Venkat wrote:
>
>>> * do you any tool to check postgreSQL database integrity check?
>>
>> No more than Oracle does. We get it right in the f
On Tue, Jun 23, 2009 at 10:24:28AM -0400, Merlin Moncure wrote:
> If you are
> adventurous/enterprising, you could dig up the hot standby patch, get
> it in line with the soon to be released 8.4, and play with it...it
> works very well.
What is the entry point for source and config documentation o
Tom Lane wrote:
Jack Orenstein writes:
Limit (cost=0.00..324.99 rows=100 width=451)
-> Index Scan using t_pkey on t (cost=0.00..296027.98 rows=91088
width=451)
Index Cond: (pk > 10)
Adding the value restriction at the top of this query plan wouldn't increase the
Hi, all.
any idea about causes and consequences?
C:\>psql -U postgres monitor
Welcome to psql 8.2.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to e
> > is around 250 lines.
>
> What I normally do for benchmarking of complex functions is to
> sprinkle the source with "raise notice '%', timeofday();" to figure
> out where the bottlenecks are. Following that, I micro-optimize
> problem queries or expressions outside of the function body in psql
Actually most of the estimates seem pretty good. There are some that
are a ways off, but the real nasties seem to be these. I'm a bit
confused because it looks like two of your joins don't have Join
Filters -- and one of those is a left join for which I thought that
was impossible.
Are you sure th
Dario Teixeira writes:
> I doubt there is a clean way around this (barring Postgresql implementing
> option types). Therefore, I'm working on a workaround that involves the
> Postgresql side annotating the nullability of type definitions by issuing
> comments on the type (using COMMENT ON). Yes,
I've a temporary table where I'd like to resume data coming from
several other tables (normalised the usual way).
eg.
a list of items that may belong to several group (eg. item,
group, itemgroup table) will end up in something similar to:
create temp table itemlisttemp(
lid int,
iid int,
qty
2009/6/23 DaNieL..! :
> The `problem` is that i dont know if having so many indexes will raise
> problems as the data dimension grown.
> That seem to be not very efficient: http://explain.depesz.com/s/Q0m
Well, this is slow, because for some reason postgres decided to use
seq scan on contact e.
A
Hi,
> Why do you think that's a useful activity for client-side
> code to engage in?
Strongly typed languages like Ocaml and Haskell deal with the possibility
of missing values by having "option types". Though at first glance SQL's
NULL seems like a similar concept, in fact NULL is more like a
2009/6/23 Devrim GÜNDÜZ :
> On Mon, 2009-06-22 at 18:28 -0400, Gerry Reno wrote:
>> The only one that is remotely viable is slony and it is so quirky you
>> may as well forget it.
>
> Like what? I agree that Slony-I is not a plug-in-play replication
> solution, but I don't agree that it is so quirk
On Tue, Jun 23, 2009 at 3:04 PM, Tom Lane wrote:
> Merlin Moncure writes:
>> On Tue, Jun 23, 2009 at 8:03 AM, Hartman,
>> Matthew wrote:
>>> Is there a recommended approach when trying to use EXPLAIN on a
>>> function? Specifically, a function that is more than the typical SELECT
>>> statement or
This looks like data corruption on that record. Or possibly on
multiple records.
I would:
a) update to the latest bug-fix release of 8.2 asap. I don't see any
fixed bugs which would cause this specific type of error but there are
a lot of them and I could have missed it.
http://www.postgresql.o
The `problem` is that i dont know if having so many indexes will raise
problems as the data dimension grown.
And i am not even sure that this design is truly reliable;
For example, if i would to know how many employees have every company,
i'll have to run that query:
-
EXPLAIN ANALYZE
SELECT
On Tue, Jun 23, 2009 at 02:30:50PM +0100, Dave Page wrote:
> On Tue, Jun 23, 2009 at 2:26 PM, David Fetter wrote:
>
> >> Auditors can be a funny breed.
> >
> > They can, at that, but in this case, they're simply doing the
> > normal human thing of trying to figure out whether there's a way
> > the
Jack Orenstein writes:
>Limit (cost=0.00..324.99 rows=100 width=451)
> -> Index Scan using t_pkey on t (cost=0.00..296027.98 rows=91088
> width=451)
>Index Cond: (pk > 10)
> Adding the value restriction at the top of this query plan wouldn't increase
> the
> cos
Merlin Moncure writes:
> On Tue, Jun 23, 2009 at 8:03 AM, Hartman,
> Matthew wrote:
>> Is there a recommended approach when trying to use EXPLAIN on a
>> function? Specifically, a function that is more than the typical SELECT
>> statement or tiny loop. The one in question that I'm hoping to optimi
Sam Mason wrote:
On Mon, Jun 22, 2009 at 05:55:28PM -0400, Jack Orenstein wrote:
ris-# select *
ris-# from T
ris-# where pk > 10
ris-# and value = 'asdf'::bytea
ris-# order by pk
ris-# limit 100;
PG thinks that you're going to get 16 rows back matching those
conditions, bitmap heap sca
Hy the raise notice is a good idea, thanks. I use raise notice
already for other uses, may as well go with it. Thanks.
Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kingston General Hospital
(613) 549- x4294
-Original Message-
From: Merlin Moncure [mailto:mmon
darioteixe...@yahoo.com writes:
> Thanks for the info. So, given that RowDescription is a dead-end, is there
> any other way I can determine the composite type associated with a function
> return?
Why do you think that's a useful activity for client-side code to engage
in?
On Tue, Jun 23, 2009 at 2:26 PM, David Fetter wrote:
>> Auditors can be a funny breed.
>
> They can, at that, but in this case, they're simply doing the normal
> human thing of trying to figure out whether there's a way they can
> push off their work to someone or something else. In this case, th
On Tue, Jun 23, 2009 at 02:17:02PM +0100, Dave Page wrote:
> On Tue, Jun 23, 2009 at 2:11 PM, David Fetter wrote:
>
> > There is no general way to do that, apart from creating a test suite
> > specific to your scenario and hoping it doesn't have more bugs that
> > the thing it's testing.
>
> You
On Tue, Jun 23, 2009 at 8:03 AM, Hartman,
Matthew wrote:
> Is there a recommended approach when trying to use EXPLAIN on a
> function? Specifically, a function that is more than the typical SELECT
> statement or tiny loop. The one in question that I'm hoping to optimize
> is around 250 lines.
What
On Tue, Jun 23, 2009 at 2:11 PM, David Fetter wrote:
> There is no general way to do that, apart from creating a test suite
> specific to your scenario and hoping it doesn't have more bugs that
> the thing it's testing.
You don't have to tell me that :-)
> Sometimes it's good not to agree with t
On Tue, Jun 23, 2009 at 02:00:51PM +0100, Dave Page wrote:
> On Tue, Jun 23, 2009 at 1:38 PM, David Fetter wrote:
> > On Tue, Jun 23, 2009 at 03:38:35PM +0800, Prasad, Venkat wrote:
>
> >> * do you any tool to check postgreSQL database integrity check?
> >
> > No more than Oracle does. We get it
Hi,
> It's intentional; IIRC, the current behavior is defined that way because
> that's what the JDBC driver needs to implement the JDBC specs. Putting
> information about composite types where information about tables is
> expected would confuse the heck out of existing client code.
Thanks for
On Tue, Jun 23, 2009 at 1:38 PM, David Fetter wrote:
> On Tue, Jun 23, 2009 at 03:38:35PM +0800, Prasad, Venkat wrote:
>> * do you any tool to check postgreSQL database integrity check?
>
> No more than Oracle does. We get it right in the first place. The
> existence of "integrity checking" tool
Hi,
> It is not as elegant as you would like, but maybe one idea
> is to create your own alias of the built in type so you can
> determine the answer just by looking at the column type. For
> example, instead of using "int" in CREATE TYPE above, create
> a your own type equivalent to an integer.
On Tue, Jun 23, 2009 at 03:38:35PM +0800, Prasad, Venkat wrote:
> Hello,
>
> Please can you assist on following questions.
This is an issue for pgsql-general, where I'm redirecting this.
>
> * do you any tool to check postgreSQL database integrity check?
No more than Oracle does. We get it rig
Craig Ringer wrote:
On Mon, 2009-06-22 at 22:20 -0400, Gerry Reno wrote:
Here is a link that describes the technique:
http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html?page=1
Ah. You were referring to multiple-master replication, and your
reference to setti
Hi, All
I hope to call some backend function via PQfn(), such as hash and nbtree.
Can we do it? How to do? Many thanks.
Best regards,
Bruce
Tom Lane-2 wrote:
>
> BlackMage writes:
>> I am having a small issue when entering values into the interval field.
>> Say
>> I want to enter a time of 2:03, two minutes and 3 seconds. When I insert
>> that into an interval field, it comes up at 02:03:00, 2 hours, 3 minutes.
>> The only way I'v
Is there a recommended approach when trying to use EXPLAIN on a
function? Specifically, a function that is more than the typical SELECT
statement or tiny loop. The one in question that I'm hoping to optimize
is around 250 lines.
Thanks,
Matthew Hartman
Programmer/Analyst
Information Management, I
On 2009-06-23, Craig Ringer wrote:
>
> With Pg it'd break any existing connections, but any database
> application worth a damn must be able to handle re-issuing transactions
> due to deadlocks, resource exhaustion, admin statement cancellation etc
> anyway.
Any app that dies when the database so
Much better than explain-analyze.info
Many thanks!
Am 23.06.2009 um 11:25 schrieb Dragan Sahpaski:
Viktor Rosenfeld wrote:
Thank you, this does indeed look very nice.
I would still be interested in alternatives, though. Specifically,
I want to be able to quickly see the cost of query subp
it looks ok on explain, that is - the cost isn't too high.
So what's the problem ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Almost forgot: one fo the heavier select query can be:
-
SELECT
contact.id,
contact.company_id,
contact.name AS nome,
contact.surname AS cognome,
contact.email AS email,
contact.company_name AS azienda
FROM
contact
WHERE
(
lower(contact.company_name) LIKE 's
Hi guys, im tryin to optimize a simple table, suited for contain
users.
So, my table at the moment is:
-
CREATE TABLE contacts(
id BIGSERIAL PRIMARY KEY NOT NULL UNIQUE,
company_id BIGINT,
code varchar(10),
company_name varchar(120),
name varchar(120),
surname varchar(120),
phone varcha
On Tue, Jun 23, 2009 at 10:54 AM, Sim Zacks wrote:
> Sim Zacks wrote:
>> Grzegorz Jaśkiewicz wrote:
>>> give us postgresql version as well, maybe show query and at least table
>>> layout.
>>>
>>
> The queries look like (The one I'm trying to run is the last one, which
> is based on all the previou
Grzegorz Jaśkiewicz wrote:
> give us postgresql version as well, maybe show query and at least table
> layout.
>
"PostgreSQL 8.2.4 on i386-pc-linux-gnu, compiled by GCC
i386-pc-linux-gnu-gcc (GCC) 4.1.1 (Gentoo 4.1.1)"
It is a view based on 4 layers of views with a lot of tables and
functions t
Sim Zacks wrote:
> Grzegorz Jaśkiewicz wrote:
>> give us postgresql version as well, maybe show query and at least table
>> layout.
>>
>
The queries look like (The one I'm trying to run is the last one, which
is based on all the previous ones).:
CREATE OR REPLACE VIEW assembliesstockbatch AS
SE
Oh, probably found the cause of the sudden restarts:
Jun 23 09:39:13 ph1phys01 genunix: [ID 603404 kern.notice] NOTICE: core_log:
postgres[25239] core dumped: /var/core/core_global.postgres
Jun 23 09:45:56 ph1phys01 genunix: [ID 603404 kern.notice] NOTICE: core_log:
postgres[26455] core dumped: /v
For a certain record in our database I'm getting cache lookup failures
(ERROR: cache lookup failed for type 70385664). And only for one of
the 2 array columns in that record.
The table definition is:
\d inhoudingen
Table "public.inhoudingen"
Column|
On Tue, Jun 23, 2009 at 11:03 AM, Devrim GÜNDÜZ wrote:
> I *used* MySQL replication, and I do know what it means. It is not user
> friendly, come on.
Well, I used it too - it is. If you want to replicate _everything_.
Never had troubles with it, but that was database holding stuff for
Zope, rest
On Tue, 2009-06-23 at 11:00 +0100, Grzegorz Jaśkiewicz wrote:
> > Either you did not use MySQL Replication, or you don't know what
> good
> > means...
>
> He is referring to user friendliness, and you to quality and
> reliability.
I *used* MySQL replication, and I do know what it means. It is not
2009/6/23 Devrim GÜNDÜZ :
> On Mon, 2009-06-22 at 17:53 -0400, Gerry Reno wrote:
>> We need something as good as MySQL Replication.
>
> Either you did not use MySQL Replication, or you don't know what good
> means...
He is referring to user friendliness, and you to quality and reliability.
This is
On Mon, 2009-06-22 at 18:28 -0400, Gerry Reno wrote:
> The only one that is remotely viable is slony and it is so quirky you
> may as well forget it.
Like what? I agree that Slony-I is not a plug-in-play replication
solution, but I don't agree that it is so quirky.
> The rest are in some stage o
On Mon, 2009-06-22 at 17:53 -0400, Gerry Reno wrote:
> We need something as good as MySQL Replication.
Either you did not use MySQL Replication, or you don't know what good
means...
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, dev
Hi Mike
thanks for your interest in rubyrep. I developed rubyrep. Let me
answer your questions.
On Jun 23, 4:16 pm, m...@kitchenpc.com (Mike Christensen) wrote:
> There will be a set of triggers for each replication. Since MySql doesn't
> support more than one trigger on a table, this approach w
Note to self: better proof reading...
On Jun 23, 6:14 pm, Arndt Lehmann wrote:
> If let's say C goes down, then replication between A and B will not be
> affected.
> Same if A goes down: replication between B and C will continue.
Correct:
Let's say B goes down, then replication between A and C wi
Viktor Rosenfeld wrote:
Thank you, this does indeed look very nice.
I would still be interested in alternatives, though. Specifically, I
want to be able to quickly see the cost of query subplans á la
http://explain-analyze.info. A tool that outputs a dot file or
something which I can furthe
give us postgresql version as well, maybe show query and at least table layout.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> increase default_statistics_target to 100 for instance, and retry.
I changed the setting, reloaded the configuration (without restarting
the server) ran vacuum analyze and the results were the exact same.
Any other thoughts?
Sim
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
Thank you, this does indeed look very nice.
I would still be interested in alternatives, though. Specifically, I
want to be able to quickly see the cost of query subplans á la http://explain-analyze.inf
o. A tool that outputs a dot file or something which I can further
edit would also work
common mistake is - you didn't vacuum analyze your table at all, after
inserting so much data in it.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Rubyrep looks very interesting, I just watched their 5min video and looks
very easy to setup.
Few questions.. The left/right database looks very limiting (you can only
replicate two databases at a time).. Their documentation says that the
solution is to setup a chain. To keep A, B and C in sync
98 matches
Mail list logo
