Hello,
I found strange PostgreSQL 9.3 behavior:
> select now()::timestamp, 'now()'::timestamp;
now | timestamp
+
2014-08-22 08:34:00.883268 | 2014-08-22 08:34:00.883268
Second column is now() in single apost
Thank you for the guidance! So far so good with
max_standby_archive/streaming_delay, no cancellations.
Hi Postgresql users,
I have a master table with two partition table (food_2013p, food_2014p).
I found that when I use SELECT + 'now' constant, constraint exclusion works,
(it skipped the 2013 partition).
EXPLAIN ANALYZE
SELECT *
FROM food
WHERE food.post_timestamp >= ('now'::date - interva
Hi Ken,
Thanks for reply.
1.
The problem is that using 'now' in VIEW, the resulting VIEW will hard code the
current timestamp.
It is not dynamic.
If I use write the view like this:
WHERE food.post_timestamp >= ('now'::date - interval '1 month')::timestamp
without time zone
AND food.post_time
Steve Kehlet wrote:
> Our queries on our Standby are getting cancelled and so we're investigating
> how to prevent this. The standby is for running periodic reporting queries
> only, we don't care if it falls behind a little bit, we just set this guy
> up to reduce the load on the Primary.
>
> Whi
On 8/21/2014 1:44 PM, Steve Kehlet wrote:
Our queries on our Standby are getting cancelled and so we're
investigating how to prevent this. The standby is for running periodic
reporting queries only, we don't care if it falls behind a little bit,
we just set this guy up to reduce the load on the
On 08/21/2014 03:44 PM, Steve Kehlet wrote:
So we're going to try applying max_standby_archive_delay and
max_standby_streaming_delay to 1h or so. We're also looking at
pg_xlog_replay_pause(), although this is less desirable because we
don't want to have to ask the people running reports to remem
Our queries on our Standby are getting cancelled and so we're investigating
how to prevent this. The standby is for running periodic reporting queries
only, we don't care if it falls behind a little bit, we just set this guy
up to reduce the load on the Primary.
While researching there appear to b
On 21 August 2014 15:41, Victor d'Agostino
wrote:
> I'm updating this column (for more than 48 hours now) on a RAID5 server.
>
RAID5? That's probably the worst performing RAID configuration you can have
and is usually advised against on this list.
You would be better off with RAID 10, RAID 1+0
On 21/08/2014 14:41, Victor d'Agostino wrote:
> Hi everybody,
>
> I added a datetime column to a table with 51.10^6 entries.
>
> ALTER TABLE MYBIGTABLE ADD COLUMN date timestamp without time zone;
>
> I'm updating this column (for more than 48 hours now) on a RAID5
> server.
>
> UPDATE MYBIGTAB
On 08/21/2014 08:41 AM, Victor d'Agostino wrote:
UPDATE MYBIGTABLE SET date = (SELECT date FROM INDEXEDTABLE WHERE
INDEXEDTABLE.email_id=MYBIGTABLE.email_id) WHERE date is null;
I may be wrong here, but wouldn't this style of query force a nested
loop? Over several million rows, that would ta
Hi everybody,
I added a datetime column to a table with 51.10^6 entries.
ALTER TABLE MYBIGTABLE ADD COLUMN date timestamp without time zone;
I'm updating this column (for more than 48 hours now) on a RAID5 server.
UPDATE MYBIGTABLE SET date = (SELECT date FROM INDEXEDTABLE WHERE
INDEXEDTABLE
Hi all,
I got a typo in last mail, below is the updated one, with changes in bold fonts.
The method is inspired by Date LastDay - PostgreSQL wiki
Date LastDay - PostgreSQL wiki
Snippets Date LastDay() Works with PostgreSQL Any version Written in SQL
Depends on Nothing by Scott Bai
> EXPLAIN ANALYZE
> SELECT *
>FROM food
> WHERE food.post_timestamp >= ('now'::date - interval '1 month')::date AND
> food.post_timestamp <= 'now'
> ORDER BY food.post_timestamp DESC
> LIMIT 30;
I think the problem is that you're using 'now'::date in your first example,
which gets froz
An update, inspired by Date LastDay - PostgreSQL wiki
Date LastDay - PostgreSQL wiki
Snippets Date LastDay() Works with PostgreSQL Any version Written in SQL
Depends on Nothing by Scott Bailey 'Artacus'
View on wiki.postgresql.org Preview by Yahoo
1. Create a function like:
Resent. As I could not see my mail in the mailing list after about two hours.
On Thursday, August 21, 2014 1:43 PM, Patrick Dung
wrote:
Hi Postgresql users,
I have a master table with two partition table (food_2013p, food_2014p).
I found that when I use SELECT + 'now' constant, constrain
16 matches
Mail list logo
