On Tue, Oct 1, 2013 at 10:48 PM, Sergey Konoplev wrote:
> On Tue, Oct 1, 2013 at 6:15 PM, Jaime Casanova wrote:
>
>> but it would be a good idea to set hot_standby_feedback to on and
>> max_standby_archive_delay to something larger than 30s
>
> Doesn't replica need a connection to master for hot_
(2013/10/02 17:37), KONDO Mitsumasa wrote:
> I want to submit new project in pgFoundery project.
Our new project was approved yesterday!
Thanks very much for pgFoundery crew.
Regards,
--
Mitsumasa KONDO
NTT Open Source Software Center
--
Sent via pgsql-general mailing list (pgsql-general@postg
On 10/02/2013 02:53 PM, Tim Uckun wrote:
I do think it would help to add it to the docs. The name "TIMESTAMP WITH
TIME ZONE" clearly implies the time zone is stored in the field. One
day there will really be a timestamp with time zone embedded in it field
and I wonder what they will call that.
I do think it would help to add it to the docs. The name "TIMESTAMP WITH
TIME ZONE" clearly implies the time zone is stored in the field. One day
there will really be a timestamp with time zone embedded in it field and I
wonder what they will call that.
On Wed, Oct 02, 2013 at 10:40:36AM -0700, Steve Crawford wrote:
> >>>The reason for that is that in PostgreSQL there is no time zone
> >>information stored along with a "timestamp with time zone",
> >>it is stored in UTC.
> >A better name might perhaps been "timezone aware timestamp".
> >
> >Karst
On Wed, Oct 2, 2013 at 9:01 AM, David Rysdam wrote:
> I had some vague notion of tables "doing work" but really if it can load
> one
> partition into RAM and get most of my hits from there, it'd be a big
> win.
The same concept applies to the frequently-used indexes on that partition.
On Wed, Oct 2, 2013 at 11:08 AM, Víctor Cosqui wrote:
> Hi all
>
>
> I am developing an application which uses postgres 9.2 to store binaries as
> oid objects.
>
> CREATE TABLE content (contentname text, contentoid oid);
>
> I am making some tests to evaluate how much HD space I will need to alloc
On 10/02/2013 01:49 AM, Tim Uckun wrote:
>The reason for that is that in PostgreSQL there is no time zone
information stored along with a "timestamp with time zone",
it is stored in UTC.
That seems unintuitive. What is the difference between timestamp
without time zone and timestamp with time z
> "Merlin" == Merlin Moncure writes:
>> Who is pgFoundery administrator or board member now? I would like
>> to send e-mail them. At least, it does not have information and
>> support page in pgFoundery homepage.
Merlin> I have not been able to get in contact with Marc either to
Merlin>
On 10/02/2013 04:19 AM, Karsten Hilbert wrote:
On Wed, Oct 02, 2013 at 09:49:38PM +1300, Tim Uckun wrote:
The reason for that is that in PostgreSQL there is no time zone
information stored along with a "timestamp with time zone",
it is stored in UTC.
A better name might perhaps been "timezone
David Rysdam wrote:
> Would the planner be smart enough to figure out ranges without me
> having to "hint" my queries?
Yes, it handles ranges well.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-general mailing list (pgsql-general@postg
Thanks to all
I have fix that refactoring the function
BEGIN
arr := regexp_split_to_array(_imeis, E'\\s+');
RETURN QUERY
SELECT
gpstracking_device_tracks.imei,
gpstracking_device_tracks.device_id,
gpstracking_device_tracks.date_time_process,
gpstracking_device_tracks.latitude,
gpstracking_de
Hi all
I am developing an application which uses postgres 9.2 to store binaries as
oid objects.
CREATE TABLE content (contentname text, contentoid oid);
I am making some tests to evaluate how much HD space I will need to
allocate these objects.
To measure the space used by postgres I have used
On Wed, Oct 2, 2013 at 10:42 AM, Marc Fournier wrote:
>
> direct_cp project approved, sorry for delay …
>
> as to the the mailing list issue, where did you send it? can you resend it
> to me here?
sure -- I had sent it initially to the www list then directly to you..
"Trying to figure out wha
On Wed, 2 Oct 2013 11:19:58 -0400, Kevin Grittner wrote:
> David Rysdam wrote:
>
> > We have a by-our-standards large table (about 40e6 rows). Since it is
> > the bottleneck in some places, I thought I'd experiment with
> > partitioning.
>
> In my personal experience I have gone into hundreds o
direct_cp project approved, sorry for delay …
as to the the mailing list issue, where did you send it? can you resend it to
me here?
On 2013-10-02, at 6:46 , Merlin Moncure wrote:
> On Wed, Oct 2, 2013 at 3:37 AM, KONDO Mitsumasa
> wrote:
>> Hi,
>>
>> I want to submit new project in pgFo
David Rysdam wrote:
> We have a by-our-standards large table (about 40e6 rows). Since it is
> the bottleneck in some places, I thought I'd experiment with
> partitioning.
In my personal experience I have gone into hundreds of millions of
rows with good performance without partitioning. It's all
On 10/02/2013 05:58 AM, Karsten Hilbert wrote:
On Wed, Oct 02, 2013 at 11:48:02AM +, Albe Laurenz wrote:
Or does that still need some C sprinkling (for operator support, say) ?
Exactly. If you want "<" to work right for this data type
that's the road you have to go.
I see.
Whatever bec
On Wed, Oct 02, 2013 at 02:09:23PM +, Albe Laurenz wrote:
> Karsten Hilbert wrote:
> > Whatever became of the 2011 intent to implement
> > the above that's linked to in the blog post ?
>
> You'd have to ask Alvaro.
I figured he'd maybe read this on-list :-)
Karsten
--
GPG key ID E4071346 @
Karsten Hilbert wrote:
> Whatever became of the 2011 intent to implement
> the above that's linked to in the blog post ?
You'd have to ask Alvaro.
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresq
On Mon, Sep 30, 2013 at 10:03 AM, Carlos Eduardo Sotelo Pinto
wrote:
>
> I need a help on postgresql performance
>
> I have configurate my postgresql files for tunning my server, however it is
> slow and cpu resources are highter than 120%
>
> I have no idea on how to solve this issue, I was tryin
On Wed, Oct 2, 2013 at 3:37 AM, KONDO Mitsumasa
wrote:
> Hi,
>
> I want to submit new project in pgFoundery project.
>
> I submitted new project which is WAL archive copy tool with directIO method in
> pgFoundery homepage 2 weeks ago, but it does not have approved and responded
> at
> all:-(
>
>
On Wed, 2 Oct 2013 09:12:02 -0400, Bill Moran wrote:
> Last I looked, the partitioning mechanism isn't _quite_ as smart as could
> be desired. For example:
> SELECT * FROM table WHERE objnum = 5; -- will not take advantage of partition
> You have to give the planner a little more hint as to the f
On Wed, Oct 02, 2013 at 11:48:02AM +, Albe Laurenz wrote:
>> Or does that still need some C sprinkling (for operator support, say) ?
>
> Exactly. If you want "<" to work right for this data type
> that's the road you have to go.
I see.
Whatever became of the 2011 intent to implement
the abo
On Wed, 2 Oct 2013 08:34:44 -0400
David Rysdam wrote:
> We have a by-our-standards large table (about 40e6 rows). Since it is
> the bottleneck in some places, I thought I'd experiment with
> partitioning. I'm following the instructions here:
>
> http://www.postgresql.org/docs/current/static/
On Wed, 2 Oct 2013 08:34:44 -0400, David Rysdam wrote:
> However, when I run an explain or an explain analyze, I still seeing it
> checking both partitions. Is this because the query planner doesn't want
> to do a mod? Should I go with simple ranges, even though this adds a
> maintenance task?
I
We have a by-our-standards large table (about 40e6 rows). Since it is
the bottleneck in some places, I thought I'd experiment with
partitioning. I'm following the instructions here:
http://www.postgresql.org/docs/current/static/ddl-partitioning.html
The table holds data about certain objects,
Karsten Hilbert wrote:
> > > Maybe the question I need to ask is "how can I store the time zone along
> > > with the timestamp"
> >
> > Store an additional field "offset".
> > If you want to invest more energy and don't mind writing C,
> > you could create your own data type.
>
> Might not a comp
On Wed, Oct 02, 2013 at 09:18:30AM +, Albe Laurenz wrote:
> > Maybe the question I need to ask is "how can I store the time zone along
> > with the timestamp"
>
> Store an additional field "offset".
> If you want to invest more energy and don't mind writing C,
> you could create your own dat
On Wed, Oct 02, 2013 at 09:49:38PM +1300, Tim Uckun wrote:
> >The reason for that is that in PostgreSQL there is no time zone
> information stored along with a "timestamp with time zone",
> it is stored in UTC.
A better name might perhaps been "timezone aware timestamp".
Karsten
--
GPG key ID E
On Wed, Oct 02, 2013 at 09:49:38PM +1300, Tim Uckun wrote:
> Maybe the question I need to ask is "how can I store the time zone along
> with the timestamp"
You need an extra field, say, of type interval.
Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9
On Wed, Oct 2, 2013 at 5:37 PM, KONDO Mitsumasa
wrote:
> Who is pgFoundery administrator or board member now? I would like to send
> e-mail
> them. At least, it does not have information and support page in pgFoundery
> homepage.
Why don't you consider github as a potential solution? You could u
Tim Uckun wrote:
>> The reason for that is that in PostgreSQL there is no time zone
>> information stored along with a "timestamp with time zone",
>> it is stored in UTC.
>
> That seems unintuitive. What is the difference between timestamp without time
> zone and timestamp with
> time zone? I was
That's interesting article but it tells me that I can't really use the
timestamp with time zone data type. I really need to store the time zone
information along with the datetime and do not want to automatically
convert the timestamp to the connection time zone.
If one row has a timestamp in UT
On 02/10/2013, at 6:49 PM, Tim Uckun wrote:
> >The reason for that is that in PostgreSQL there is no time zone
> information stored along with a "timestamp with time zone",
> it is stored in UTC.
>
> That seems unintuitive. What is the difference between timestamp without time
> zone and times
>The reason for that is that in PostgreSQL there is no time zone
information stored along with a "timestamp with time zone",
it is stored in UTC.
That seems unintuitive. What is the difference between timestamp without
time zone and timestamp with time zone? I was expecting to have the time
zone s
> Hi,
>
> I want to submit new project in pgFoundery project.
>
> I submitted new project which is WAL archive copy tool with directIO method in
> pgFoundery homepage 2 weeks ago, but it does not have approved and responded
> at
> all:-(
>
> Who is pgFoundery administrator or board member now?
Hi,
I want to submit new project in pgFoundery project.
I submitted new project which is WAL archive copy tool with directIO method in
pgFoundery homepage 2 weeks ago, but it does not have approved and responded at
all:-(
Who is pgFoundery administrator or board member now? I would like to send
Tim Uckun wrote:
> I have the following query.
[...]
> SELECT
> interval_start,
> (interval_start AT TIME ZONE 'Africa/Monrovia')::timestamp with time zone as
> interval_start_in_africa,
> min_datetime,
> min_datetime AT TIME ZONE 'Europe/Berlin' as min_datetime_in_berlin,
> max_datetime,
39 matches
Mail list logo
