On Aug 10, 2006, at 1:57 AM, John Sidney-Woollett wrote:
Disagree.
We only apply reindex on tables that see lots of updates...
With our 7.4.x databases we vacuum each day, but we see real
performance gains after re-indexing too - we see lower load
averages and no decrease in responsiveness
On Aug 9, 2006, at 10:31 PM, Matthew T. O'Connor wrote:
Jim C. Nasby wrote:
Take a look at http://pgfoundry.org/projects/pgpitrha/
I had already seen this however it says that this project has yet
to release any files, so I thought it was a dead project. Am I
missing something?
No, the
On Fri, Aug 18, 2006 at 09:27:19AM -0700, Bob Pawley wrote:
> I need to insert data from one table into three other tables.
>
> I attempted the following format.
[...]
> insert into p_id.loops (monitor)
> Select p_id.devices.devices_id
> Where p_id.devices.device_number = library.devices.devi
On 8/18/06, Bob Pawley <[EMAIL PROTECTED]> wrote:
Unfortunately this gave multiple results on the target tables.
Is there a format that will give me a single insert for each original field
without the need of creating three triggers???
Bob
try using old/new in your trigger functions.
insert
[EMAIL PROTECTED] writes:
> Suppose I have an index on 5 columns (A, B, C, D, E).
> If my WHERE clause is not in that order, will the optimizer reorder
> them as necessary and possible?
Yes, the optimizer understands about commutativity/associativity of
AND and OR ;-)
> If I don't specify co
Suppose I have an index on 5 columns (A, B, C, D, E).
If my WHERE clause is not in that order, will the optimizer reorder
them as necessary and possible?
WHERE A=1 AND C=3 AND B=2 AND E=5 AND D=4
Obviously it can't reorder them in all cases:
WHERE A=1 AND (C=3 OR B=2) AND (E=5 OR D
On Fri, Aug 18, 2006 at 06:01:02PM +0200, Michael Meskes wrote:
> On Tue, Aug 15, 2006 at 07:31:31PM -0600, Michael Fuhr wrote:
> > Will that be a minor fix that can be backpatched or will it be
> > invasive enough to be fixed only in HEAD? I'll submit a documentation
>
> I just fixed it and appl
On 8/18/06, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> the .net 'way' of database application development is to keep all
> the logic in the .net middleware. please note that I am completely
> opposed to this because it obfuscates good data management
> practices.
> however based on the op's co
Hi All
I have a basic problem that I hope can be
addressed.
I need to insert data from one table into three other
tables.
I attempted the following format.
CREATE OR REPLACE FUNCTION p_id_monitor() RETURNS
"trigger" AS $$ Begin insert into p_id.loops
(monitor) Select p_id.devices.d
On Tue, Aug 15, 2006 at 07:31:31PM -0600, Michael Fuhr wrote:
> Will that be a minor fix that can be backpatched or will it be
> invasive enough to be fixed only in HEAD? I'll submit a documentation
I just fixed it and applied the patch to 8.0 and 8.1 too. Please test
it.
7.4 is way more differe
"Magnus Hagander" <[EMAIL PROTECTED]> writes:
>>> Does it have to be a specific city? I'd rather it just chose GMT.
>>
>> The fact that there is an entry for "GMT Daylight Time" means that
>> Windows' idea of this time zone is not pure GMT. Or is the
>> translation table entry a complete work of
# [EMAIL PROTECTED] / 2006-08-18 10:00:20 +0200:
> On 8/18/06, Stephan Szabo <[EMAIL PROTECTED]> wrote:
> >When the subselect returns
> >NULL for at least one row, you fall into this sort of case.
> >
> >x NOT IN (...) is equivalent to NOT(x IN (...)) which is
> >NOT(x = ANY (...))
> >
> >x = ANY (
> Hi list !
>
> I am currently deploying two servers (Windows 2003 R2) that will be
> used as file servers as well as PostgreSQL servers.
>
> One of the server will be the main server, the other one a backup
> server (no load-balancing, only an easy-recoverage solution).
> The goal is to be able
> >> Magnus, did you have a specific reason for choosing
> Europe/Dublin, or
> >> was it just alphabetically first? Europe/London looks at least
> >> marginally closer to what one would think "GMT" means:
>
> > Does it have to be a specific city? I'd rather it just chose GMT.
>
> The fact that t
> The Windows-PosgreSQL 8.1.4 package I downloaded from the
> PostgreSQL download site (right here) does not seem to contain the
> scripts:
> pltcl_delmod
>
> pltcl_listmod
>
> pltcl_loadmod
>
> Have I missed something, or can anyone else confirm?
They're definitely not included there. Could yo
> Hi
>
> We need to deploy postgreSQL with our new app The app is designed
> in Visual Studio 2005 and deployed in its own MSI.
> Our question is - is it possible to call the postgreSQL msi from
> our MSI or is it possible to merge PostGreSQL msi into ours. We use
> Wise for Windows 6 to create ou
> > > well, since he wrote his app in vb.net he is probably using
> > > postgresql as a dumb data store, it might not be all that
> difficult.
> > > still, not a very smart move.
> >
> > so if you have functions on server side or triggers or rules...
> then
> > you need some rewrite on the app... o
Jeff Davis wrote:
On Fri, 2006-08-18 at 00:19 +0300, gustavo halperin wrote:
Create an index on the table, and then periodically move records into a
separate archive table.
Regards,
Jeff Dave
Thanks, but I have a question. If the table is a BIIG table, use
your solution i
Am 2006-08-14 16:32:08, schrieb Chris:
> --password asks for YOUR password not the new one.
SCHEISE!!! :-/
Thanks
Michelle Konzack
--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
# Debian GNU/Linux Consultant #
Michelle Konzack
In article <[EMAIL PROTECTED]>,
gustavo halperin <[EMAIL PROTECTED]> writes:
> Hello
> I'm interesting in a partial index for a rows that aren't older than
> 6 mounts, something like the sentence below:
> /CREATE INDEX name_for_the_index ON table
> (the_column_of_type_date) WHERE ( the
Hello,
thank you and sorry for asking a FAQ.
I've fixed my problem now by:
select user_id, username from phpbb_users where user_id not in
(select ban_userid from phpbb_banlist where ban_userid is not null);
but still your explanation feels illogical
to me even though I know you're right...
On
21 matches
Mail list logo
