Hello!
Is this correct?
$ select
justify_interval(t-f-i)
,t-f-i
from
(
select
timestamp '2014-1-1' as f,
timestamp '2015-1-1' as t,
interval '06:49:00' as i
) S;
justify_interval| ?column?
+
1 year 4 days
Hello,
I'm not sure if I should post here or on pgsql-hackers.
While investigating about a wrong result with my btree bloat estimation query,
I found a strange stat deviation between the average size of a value in its
table and its average size in one index on the lower expression.
Take the
On Mon, 10 Nov 2014 11:52:54 +0100
Jehan-Guillaume de Rorthais iog...@free.fr wrote:
Hello,
I'm not sure if I should post here or on pgsql-hackers.
While investigating about a wrong result with my btree bloat estimation query,
I found a strange stat deviation between the average size of a
Hello,
I found strange result when I use pg_dump described on postgresql site:
http://www.postgresql.org/docs/9.3/static/backup-dump.html
I have a database with 30 gb data and decide to archive it, postgresql
is 9.3.5 x64_86, ext4 file system, kernel 3.14.18 Slackware 14.2
(current)
On 11/10/2014 3:34 AM, Condor wrote:
Did the database dump is corrupt or not ?
try restoring them to a new database
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list
On Mon, Nov 10, 2014 at 10:07 AM, Ilya Ashchepkov koc...@gmail.com wrote:
Is this correct?
$ select
justify_interval(t-f-i)
,t-f-i
from
(
select
timestamp '2014-1-1' as f,
timestamp '2015-1-1' as t,
interval '06:49:00' as i
) S;
justify_interval|
Hi Condor.
On Mon, Nov 10, 2014 at 12:34 PM, Condor con...@stz-bg.com wrote:
I have a database with 30 gb data and decide to archive it, postgresql is
9.3.5 x64_86, ext4 file system, kernel 3.14.18 Slackware 14.2 (current)
You should have a look at your tools, it seems you have a file size
Hi Condor.
Followup, I did not spot it at first, looking at
http://www.gzip.org/zlib/rfc-gzip.html#file-format I see:
On Mon, Nov 10, 2014 at 12:34 PM, Condor con...@stz-bg.com wrote:
Hello,
I found strange result when I use pg_dump described on postgresql site:
Followup, second try.
First of all, I'd like to apologize to the list for my previous message, I
borked some finger gymnastics when switching tabs and sent and incomplete
one. My fault. Sorry.
Now what I tried to say was:
I did not spot it at first, looking at
On 11/10/2014 03:34 AM, Condor wrote:
Hello,
I found strange result when I use pg_dump described on postgresql site:
http://www.postgresql.org/docs/9.3/static/backup-dump.html
I have a database with 30 gb data and decide to archive it, postgresql
is 9.3.5 x64_86, ext4 file system, kernel
Jehan-Guillaume de Rorthais iog...@free.fr writes:
While investigating about a wrong result with my btree bloat estimation query,
I found a strange stat deviation between the average size of a value in its
table and its average size in one index on the lower expression.
ANALYZE doesn't look at
On Mon, 10 Nov 2014 09:39:23 -0500
Tom Lane t...@sss.pgh.pa.us wrote:
Jehan-Guillaume de Rorthais iog...@free.fr writes:
While investigating about a wrong result with my btree bloat estimation
query, I found a strange stat deviation between the average size of a value
in its table and its
Hi!
I've just received a new server, and I've the intention to install
Centos7 and PostgreSQL 9.3.5.
After installing the yum repo (as described in
http://www.postgresql.org/download/linux/redhat/), I've installed
everything I need with the command
yum install postgresql93
I've found this very useful:
http://people.planetpostgresql.org/devrim/index.php?/archives/82-Running-more-than-one-9.4-9.3-instance-in-parallel-on-RHEL-7.html
Atenciosamente,
Edson Carlos Ericksson Richter
On 10-11-2014 16:45, Edson Richter wrote:
Hi!
I've just received a new server, and
On Mon, Nov 10, 2014 at 1:45 AM, David Johnston
david.g.johns...@gmail.com wrote:
Yes, that is what I was referring to. The Nabble.com website showed them.
http://postgresql.1045698.n5.nabble.com/SSL-Certificates-in-Postgres-9-3-and-Windows-7-td5826230.html
Then it's more logical. Nabble
On 11/10/2014 10:45 AM, Edson Richter wrote:
Hi!
I've just received a new server, and I've the intention to install
Centos7 and PostgreSQL 9.3.5.
After installing the yum repo (as described in
http://www.postgresql.org/download/linux/redhat/), I've installed
everything I need with the command
On 11/10/2014 11:13 AM, Magnus Hagander wrote:
Then it's more logical. Nabble simply did not include that when the
email was posted. I would call that either a bug or at least a
limitation in Nabble - I think only they can figure out what's wrong
and if it's fixable. Until then, we'll have to
On Mon, Nov 10, 2014 at 8:53 PM, John R Pierce pie...@hogranch.com wrote:
On 11/10/2014 11:13 AM, Magnus Hagander wrote:
Then it's more logical. Nabble simply did not include that when the
email was posted. I would call that either a bug or at least a
limitation in Nabble - I think only they
Since we are testing...test using Nabble.com and the more-raw option...
begin quote
I also get this error message in my log file:
begin raw
end raw
end quote
Following the sentence above should be 4 lines of log file content...
Sent using the Nabble.com interface
Dave
--
View this
Discovered that a client of ours had assumed their database was running in
UTC, but turned out to be running in 'US/Eastern'. They had changed all
their systems a while ago to run in UTC but didn't realize the database was
independent of that. The postgresql.conf has
timezone = 'US/Eastern'
set
Hi,
I need to optimise and aggregate array integer values in a function and i
am doing this by below stored function :
-- type def
CREATE TYPE fun_type AS (
g_id integer,
zip_id_list integer[],
city_id_list integer[],
state_id_list integer[],
I havent been able to find much about repmgr on postgres 9.3
Is repmgr still a significant value add given the newer replication
features built in?
Thanks.
=R
--
Robin R Chauhan
CEO, Pathway Intelligence Inc
ro...@pathwayi.com
Office: 778-588-6217 Ext. 201
Cell: 604-865-0517
On 11/10/2014 4:10 PM, Robin Ranjit Singh Chauhan wrote:
I havent been able to find much about repmgr on postgres 9.3
Is repmgr still a significant value add given the newer replication
features built in?
repmgr is a management tool for setting up and controlling the built in
replication
Vinay Gupta wrote
Please let me know if there is any optimal way to finish this function in
~
2-3 secs
If you can figure out how to write that in pure SQL you might have a chance.
David J.
--
View this message in context:
On 11/10/2014 02:04 PM, Keith Fiske wrote:
Discovered that a client of ours had assumed their database was running
in UTC, but turned out to be running in 'US/Eastern'. They had changed
all their systems a while ago to run in UTC but didn't realize the
database was independent of that. The
Table A : 220 MB
Table B : 120 KB
Yeah figuring out how to write it in pure SQL.
Thanks
On Tue, Nov 11, 2014 at 6:15 AM, David G Johnston
david.g.johns...@gmail.com wrote:
Vinay Gupta wrote
Please let me know if there is any optimal way to finish this function in
~
2-3 secs
If you
On Mon, 10 Nov 2014 14:14:15 +0100
Francisco Olarte fola...@peoplecall.com wrote:
On Mon, Nov 10, 2014 at 10:07 AM, Ilya Ashchepkov koc...@gmail.com
wrote:
Is this correct?
$ select
justify_interval(t-f-i)
,t-f-i
from
(
select
timestamp '2014-1-1' as f,
Hi All,
I have source input which stores data in PostgreSQL database in JSON format.
I want to perform the analytical operation on data present in PostgreSQL and
visualize the results of operations.
I have found one open source analytical tool called Kibana (integrated with
elasticsearch)
hi,
in the pgsql documentation
(http://www.postgresql.org/docs/9.1/static/sql-createtrigger.html)
i haven't seen anything referring to: how is affected the data inserted in
the new table by a trigger Before Insert compared with a trigger After
Insert? and anything related to performance
for
29 matches
Mail list logo