Shridhar Daithankar writes:
> I am wondering, why following two values result in a shift by 3.5 hours. I
> would expect them to be identical.
> I understand that canonical time zone names could be ambiguous at times but I
> think IST is not one of them.
I don't know why you'd think that ...
sr
Hello,
I am wondering, why following two values result in a shift by 3.5 hours. I
would expect them to be identical.
I understand that canonical time zone names could be ambiguous at times but I
think IST is not one of them.
Any explanation?
---
test=# select '2012-08-07 05:24:56.
Hello,
I am trying to setup a cluster for trac databases and want to isolate each db,
by assigning a specific user to a DB.
I followed the documentation but as shown in the following example, limiting
access by connect does not seem to be working.
What am I missing?
shridhar@bhee
On Mon, Aug 06, 2012 at 08:06:05PM +0300, Condor wrote:
> I think load avg is high because before I change the servers my
> produce server
> was on 16 cpu, 24 gb memory and load avg on that server was 0.24.
> Database is the same,
Our monitoring system starts worrying about the load average if it
Hi,
I just wonder about scenario in which time range would be usefull? (I mean,
just time - not timestamp...)
We have some scenario where we use time range as settings... Concrete case
is: for each hour employee worked between 20:00 and 08:00 should be paid x,
between 08:00 - 20:00 y... ( stored
> I think load avg is high because before I change the servers my produce
> server
> was on 16 cpu, 24 gb memory and load avg on that server was 0.24.
> Database is the same,
> users that use the server is the same, nothing is changed. I dump the DB
> from old server
> and import it to new one befo
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Jeff Davis
> Sent: Monday, August 06, 2012 1:52 PM
> To: Andreas Kretschmer
> Cc: pg-general
> Subject: Re: [GENERAL] Range-Types in 9.2
>
> On Fri, 2012-08-03 at 10:
On Fri, 2012-08-03 at 10:42 -0700, Jeff Davis wrote:
> On Fri, 2012-08-03 at 17:06 +0200, Andreas Kretschmer wrote:
> > great feature, but i can't find a TIMERANGE, i want to store time-ranges,
> > for
> > instance [10:00:00,16:00:00), how can i do that?
>
> CREATE TYPE timerange AS RANGE ( subty
On 8/6/12 3:31 AM, Magnus Hagander wrote:
On Mon, Aug 6, 2012 at 11:22 AM, sunpeng wrote:
Hi,Frirends,
Are there any commands in pgsql/bin/ corresponding "create tablespace"?
I know:
createuser<==> create role
createdb<==>create database
Hi!
No, but you can always use:
psql -c
On Aug 4, 2012, at 12:24 PM, Menelaos PerdikeasSemantix wrote:
> The following page:
>
> http://www.postgresql.org/about/
>
> mentions some limits but not the following:
>
> [1] maximum number of databases per database server instance
> [2] maximum number of schemas per database
>
> Is there e
Condor wrote:
> For that reason Im asking is there a way to detect why my load avg
> is 0.88. When I run select * from pg_stat_activity;
So, on a 32 core system if you run vmstat or iostat with a short
interval during such an episode, you should be seeing about 97% idle
time for your CPUs. If
On 2012-08-06 17:38, Tomas Vondra wrote:
On 6 Srpen 2012, 16:23, Condor wrote:
Hello,
can some tell me, how I can analyze from where my server bring up
load
average ?
...
When I connect to server i see only 2 query with select * from
pg_stat_activity;
that is not complicated, select rid fro
On 06/08/12 13:31, Bruce Momjian wrote:
>> For longer terms, perhaps we should set up an URL forwarder or
>> something that the docs can link through in the cases where we really
>> need this, so we can more easily update the URLs?
> Well, the problem there is that they don't get the real URL unles
On Mon, Aug 6, 2012 at 11:26:46AM +0200, Magnus Hagander wrote:
> On Fri, Jul 27, 2012 at 3:27 AM, Bruce Momjian wrote:
> > On Wed, Jul 18, 2012 at 04:11:21PM +0200, jg wrote:
> >> Hi,
> >>
> >> The PostgreSQK documentation refers to diskchecker.pl on the page
> >> http://brad.livejournal.com/21
On Mon, 06 Aug 2012 10:27:18 -0500, Tomas Vondra wrote:
Although the OP mentioned he's using ext4, so I suppose he's running
Linux
(although I know there was some ext4 support e.g. in FreeBSD).
Still, the load average 0.88 means the system is almost idle, especially
when there's no I/O acti
On 6 Srpen 2012, 16:54, Mark Felder wrote:
> On Mon, 06 Aug 2012 09:38:33 -0500, Tomas Vondra wrote:
>
>> Load average is defined as a number of processes in the run queue
>
> That depends on if he's running Linux or BSD.
>
> http://www.undeadly.org/cgi?action=article&sid=20090715034920
Well, eve
On 08/06/2012 05:08 AM, Marek Kielar wrote:
Hi,
to complement information from the previous message:
Dnia 29 lipca 2012 12:29 Marek Kielar napisał(a):
Hi,
Dnia 28 lipca 2012 1:10 Adrian Klaver napisał(a):
What where the deleted files?
WAL, Logs, other?
at this time - a couple da
On Mon, 06 Aug 2012 09:38:33 -0500, Tomas Vondra wrote:
Load average is defined as a number of processes in the run queue
That depends on if he's running Linux or BSD.
http://www.undeadly.org/cgi?action=article&sid=20090715034920
--
Sent via pgsql-general mailing list (pgsql-general@postgre
On 6 Srpen 2012, 16:23, Condor wrote:
> Hello,
>
> can some tell me, how I can analyze from where my server bring up load
> average ?
>
> ...
>
> When I connect to server i see only 2 query with select * from
> pg_stat_activity;
> that is not complicated, select rid from table where id = 1;
> Both
Hello,
can some tell me, how I can analyze from where my server bring up load
average ?
I have one server with 128 GB memory, 32 CPU x86_64, RAID5 - 3 15k SAS
HDD ext4 fs. That is my produce server,
also is configured to send wal files over the net. Here is my
configuration:
max_connectio
Le 2012-08-06 à 01:39, Maxim Boguk a écrit :
> I know that for condition like ((field1>value1) or (field1=value1 and
> field2>value2)) I could built index on (field1, field2) and use indexable
> condition like (field1, field2) > (value1, value2).
>
> However, I have very tricky query whic
Hi,
to complement information from the previous message:
Dnia 29 lipca 2012 12:29 Marek Kielar napisał(a):
> Hi,
>
>
> Dnia 28 lipca 2012 1:10 Adrian Klaver napisał(a):
>
> > What where the deleted files?
> >WAL, Logs, other?
>
>
> at this time - a couple days after restart, the clog
On Mon, Aug 6, 2012 at 11:22 AM, sunpeng wrote:
> Hi,Frirends,
> Are there any commands in pgsql/bin/ corresponding "create tablespace"?
> I know:
> createuser <==> create role
> createdb <==>create database
Hi!
No, but you can always use:
psql -c "create tablespace foo..."
--
Magnus
On Fri, Jul 27, 2012 at 3:27 AM, Bruce Momjian wrote:
> On Wed, Jul 18, 2012 at 04:11:21PM +0200, jg wrote:
>> Hi,
>>
>> The PostgreSQK documentation refers to diskchecker.pl on the page
>> http://brad.livejournal.com/2116715.html
>> But on this page, the given link for diskchecker.pl does not ex
Hi,Frirends,
Are there any commands in pgsql/bin/ corresponding "create tablespace"?
I know:
createuser <==> create role
createdb <==>create database
Thanks!
peng
Hi.
I'm trying to work out failover and disaster recovery procedures for a
cluster of three servers. Streaming replication is being used with a high
wal_keep_segments, no log shipping is happening. I need to avoid the
several hours it takes to rebuild a hot standby from scratch.
ServerA is the ma
26 matches
Mail list logo
