Tom Lane wrote:
Kyle Bateman <[EMAIL PROTECTED]> writes:
But I'm assuming that using an interval-encoded project tree, I would
have to do something like the following to get a progency group:
select * from ledger l, proj p where p.proj_id = l.proj and p.left >
1234 and p.right < 2345;
Tom Lane wrote:
Kyle Bateman <[EMAIL PROTECTED]> writes:
But I'm assuming that using an interval-encoded project tree, I would
have to do something like the following to get a progency group:
select * from ledger l, proj p where p.proj_id = l.proj and p.left >
1234 and p.right < 2
On 11 Aug 2006 08:05:34 -0700, Andrew Hammond <[EMAIL PROTECTED]> wrote:
I've been trying to figure out a good way to manage schema changecontrol for a while now. Since I have a development background, Ireally want to find some way to check the schema into a SCM system likeCVS (for example). Just u
2006. August 11. Friday 19.26 dátummal Judith ezt írta:
>
> Is there a way to undo an update???
>
At the 1st time: I speak little english, so I sorry.
If I understand, what's your problem, maybe I can help you... Maybe...
So, if I'd like to save the inserted, deleted and/or updated rows,
then
On Tue, Aug 15, 2006 at 10:35:36AM -0400, Sumeet wrote:
>
> The reason for splitting up the dbs into differnet instances is that in case
> one of the postgres instances on the server
> goes down for some reason, it doesnt effect the other instances which are
> running on the same server. Even I do
On 8/15/06, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
On Tue, Aug 15, 2006 at 10:11:41AM -0400, Sumeet Ambre wrote:> >> The Design of the database is because our organization wants to split up> different datasets into different entities, and there might be a
> possibility that they'll run differen
On Tue, Aug 15, 2006 at 10:25:00AM -0300, Jorge Godoy wrote:
> I'd like to see some sort of data partitioning in PostgreSQL.
Sure, I think everybody would. I think it's among the more
interesting problems we have.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The plural of anecdote is not data.
On Tue, Aug 15, 2006 at 10:11:41AM -0400, Sumeet Ambre wrote:
> >
> The Design of the database is because our organization wants to split up
> different datasets into different entities, and there might be a
> possibility that they'll run different instances of postgres for each
> dataset.
I
On Thu, 2006-08-10 at 17:53, Saad Anis wrote:
> Hi Guys,
>
> A fellow at work has written the SQL below to retrieve some data from
> multiple tables. Obviously it is inefficient and unnecessarily complex, and
> I am trying to break it into 2 or more queries so as to enhance performance.
Nope, tha
Andrew Sullivan wrote:
On Mon, Aug 14, 2006 at 05:26:10PM -0400, Sumeet Ambre wrote:
Hi All,
I have a database which consists of 20 million records and I've split up
the db into 6-7 dbs.
You can do this (as someone suggested with dblink), but I'm wondering
why the split? 20 million
On Fri, 2006-08-11 at 08:58, Jonathan Sinclair wrote:
> Hi all. Thanks for your help so far. However after configuring my system
> I am still getting major lag times with a couple of queries. The first,
> which suffers from the '538/539'(see old email included below) bug, is
> caused by running the
Andrew Sullivan <[EMAIL PROTECTED]> writes:
> On Tue, Aug 15, 2006 at 09:01:03AM -0300, Jorge Godoy wrote:
>> I can think that spreading processing requirements should be one. And
>> distributing load another one. Disk space can be solved with new disks and
>> tablespaces, but we can't yet distr
On Tue, Aug 15, 2006 at 09:01:03AM -0300, Jorge Godoy wrote:
> I can think that spreading processing requirements should be one. And
> distributing load another one. Disk space can be solved with new disks and
> tablespaces, but we can't yet distribute the load through several servers
> without p
Michael Fuhr <[EMAIL PROTECTED]> writes:
> And why multiple databases instead of multiple schemas within the
> same database? Or even all data in the same schema? Is there a
> reason for the segregation?
I can think that spreading processing requirements should be one. And
distributing load an
On Tue, Aug 15, 2006 at 06:36:24AM -0400, Andrew Sullivan wrote:
> On Mon, Aug 14, 2006 at 05:26:10PM -0400, Sumeet Ambre wrote:
> > I have a database which consists of 20 million records and I've split up
> > the db into 6-7 dbs.
>
> You can do this (as someone suggested with dblink), but I'm w
On Mon, Aug 14, 2006 at 05:26:10PM -0400, Sumeet Ambre wrote:
> Hi All,
>
> I have a database which consists of 20 million records and I've split up
> the db into 6-7 dbs.
You can do this (as someone suggested with dblink), but I'm wondering
why the split? 20 million records isn't very big.
A
16 matches
Mail list logo
