Jeff Davis writes:
> Yes, that is a strange case. When you can't tell if an interval is
> positive or negative, how do you define the absolute value?
That was the point of my '1 day -25 hours' example. Whether you
consider that positive or negative seems mighty arbitrary.
On Thu, 29 Oct 2009, Vick Khera wrote:
Greg, do you have a performance tuning book? If so, I really want to
buy it! Your articles are awesome.
Give me a few more months...
basically, the next checkpoint starts within a few seconds of the prior
one completing.
That's the expected behavior
On Thu, 2009-10-29 at 16:39 -0700, Scott Bailey wrote:
> But there is some ambiguity around the length of a month. So INTERVAL '1
> month - 30 days' = INTERVAL '0 days' = INTERVAL '-1 month +30 days'.
> But when added to a date, it makes no change for months with 30 days,
> adds 1 day for month
I think this came up again recently and somebody pointed out that the
correct definition isn't as obvious as all that. The components of
an interval can have different signs, so should abs('-1 day 1 hour') be
'1 day -1 hour' or '1 day 1 hour'? Or what about corner cases like
'1 day -25 hours'?
Le jeudi 29 octobre 2009 à 02:13:51, Greg Smith a écrit :
> On Wed, 28 Oct 2009, Thom Brown wrote:
> > All we have are a summary of changes. We can find out all the
> > information if we do plenty of searching of mailing lists and comparing
> > old and new documentation, but obviously this can be
On Thu, Oct 29, 2009 at 9:34 PM, Blake Starkenburg wrote:
> I am in the midst of planning for a new database which will contain specific
> keywords relating to different products. For example a "Microwave" may have
> the keywords HOUSEHOLD -> PANASONIC -> CAROUSEL -> CONVECTION -> 2200 WATTS.
> A
>
>
>
> Initially I had planned to use Postgresql's Array Column (keywords
> varchar(100)[]) but this has some limitations when using the LIKE operator,
> making searching for specific string of words difficult unless you know
> firsthand the array key (keywords[2] LIKE 'PANA%').
>
> Does anyone ha
I am in the midst of planning for a new database which will contain specific
keywords relating to different products. For example a "Microwave" may have
the keywords HOUSEHOLD -> PANASONIC -> CAROUSEL -> CONVECTION -> 2200 WATTS.
A pair of Levis may be CLOTHING -> LEVIS -> STONEWASHED -> BOOT CUT -
On Thu, Oct 29, 2009 at 12:46 PM, Vick Khera wrote:
> On my primary DB I'm observing random slowness which just doesn't make
> sense to me. The I/O system can easily do 40MB/sec writes, but I'm
> only seeing a sustained 5MB/sec, even as the application is stalling
> waiting on the DB.
Just one p
On Thu, 2009-10-29 at 14:46 -0400, Vick Khera wrote:
> On my primary DB I'm observing random slowness which just doesn't make
> sense to me. The I/O system can easily do 40MB/sec writes, but I'm
> only seeing a sustained 5MB/sec, even as the application is stalling
> waiting on the DB.
>
> My onl
On my primary DB I'm observing random slowness which just doesn't make
sense to me. The I/O system can easily do 40MB/sec writes, but I'm
only seeing a sustained 5MB/sec, even as the application is stalling
waiting on the DB.
My only guess is that I'm getting hit by checkpoints too often, and
thi
Bob Pawley wrote:
> I am on Windows and am running an anti virus program. But I was running
> the same programs on Windows before without this problem.
Well, as long as you're happy you've ruled out your anti-virus, and
you're running 8.3.8 then you'll want to monitor it and next time it
happens r
Bob Pawley wrote:
> FATAL: could not reattach to shared memory (key=1804, addr=0170): 487
> 2009-10-29 00:19:20 PDT WARNING: worker took too long to start; cancelled
>
> Is there some way of ensuring that the server always accepts a connection?
This is a known bug, supposedly fixed in 8.3.
A. Kretschmer wrote:
http://www.postgresql.org/docs/current/static/storage-toast.html
Andreas
Thanks Andreas.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I am on Windows and am running an anti virus program. But I was running the
same programs on Windows before without this problem.
Bob
- Original Message -
From: "Richard Huxton"
To: "Bob Pawley"
Cc:
Sent: Thursday, October 29, 2009 10:24 AM
Subject: Re: [GENERAL] Can't connect
Bo
Bob Pawley wrote:
> Hi
>
> My copy of PostgreSQL version 8.3 has decided not to receive a
> connection after an idle time measured in hours.
Odd.
> It acceptes the connection one I stop the server and then restart. At
> this point, it always asks for the password.
>
> Here is the log of the eve
Hi
My copy of PostgreSQL version 8.3 has decided not to receive a connection after
an idle time measured in hours.
It acceptes the connection one I stop the server and then restart. At this
point, it always asks for the password.
Here is the log of the event -
FATAL: could not reattach to sh
Thom Brown a écrit :
...
2009/10/29 Daniel Chiaramello :
Never mind, I found how finally:
UPDATE
product
SET
qty = qty+s_count
FROM (
SELECT
intermediate.product_id,
count(*) AS s_count
FROM
intermediate,
orders
WHERE
On Thu, Oct 29, 2009 at 12:05:54PM +0200, Sim Zacks wrote:
> 326/getdisplayconversionmultiplebypn(pnid) is in this query 6 times. How
> many times is it evaluated?
I'm pretty sure it'll evaluated multiple times. Why don't you put it
into a sub-select, it'll at least save some typing. Something l
2009/10/29 Daniel Chiaramello :
> Never mind, I found how finally:
>
> UPDATE
> product
> SET
> qty = qty+s_count
> FROM (
> SELECT
> intermediate.product_id,
> count(*) AS s_count
> FROM
> intermediate,
> orders
> WHERE
> orde
Never mind, I found how finally:
UPDATE
product
SET
qty = qty+s_count
FROM (
SELECT
intermediate.product_id,
count(*) AS s_count
FROM
intermediate,
orders
WHERE
orders.intermediate_id=intermediate.id
GROUP BY
In response to Howard Cole :
> Hi everyone,
>
> Is data compressed when stored in a database table/field?
http://www.postgresql.org/docs/current/static/storage-toast.html
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006
Hi everyone,
Is data compressed when stored in a database table/field?
If not, is there an easy way (invisible to the database client) to
compress text and bytea data without actually using compressed disks?
Thanks.
Howard
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-gene
Hello.
I have a very basic question, relative to the following "problem".
I have the following tables:
product
id
qty
intermediate
id
product_id
orders
intermediate_id
I want to update the "qty" field of the "product" table by incrementing
it each time there is an order in th
On Wed, Oct 28, 2009 at 05:45:14AM -0700,
Xai wrote
a message of 2 lines which said:
> i want to create a type for an email field but i'm not good with regx
Do not even try.
http://stackoverflow.com/questions/201323/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
2009/10/28 Richard Huxton :
> Xai wrote:
>> i want to create a type for an email field but i'm not good with regx
>> can some one help me?
>
> Google for "email regex". Be warned - this is very complicated if you
> want to match *all* possible email addresses.
>
Just send your users an email askin
I have a query which includes the same calculation and function call
multiple times.
Is the calculation and function call evaluated one time or as many times
as it is in the query?
Example:
326/getdisplayconversionmultiplebypn(pnid) is in this query 6 times. How
many times is it evaluated?
sel
On 28 Oct 2009, at 14:51, fox7 wrote:
I copy the results derived by istruction "EXPLAIN ANALYZE" for the two
query...
For a next time, if you attach that output as text files they won't
get wrapped by e-mail clients, making them a bit easier to read. Also,
this looks like output from pg_a
28 matches
Mail list logo
