On Mon, Aug 4, 2014 at 7:56 PM, M Tarkeshwar Rao
wrote:
> Is it always creating core files on /var/lib/postgresql/8.4/main path for
> ubuntu?
I don't recall for ubuntu, but on Linux for sure you can see how a
core file is shaped by looking at /proc/sys/kernel/core_pattern. Just
noticing something.
On 8/1/2014 8:17 AM, Ramesh T wrote:
How to improve performence of postgres 9.3 database.And also
in oracle web based Enterprise manger is available,in postgres any
tool their to monitor and change.
please let me know performence related info to my postgres 9.3
database.and any tool
On Sat, Aug 2, 2014 at 12:17 AM, Ramesh T wrote:
> Hello,
> How to improve performence of postgres 9.3 database.And also in
> oracle web based Enterprise manger is available,in postgres any tool their
> to monitor and change.
>
> please let me know performence related info to my postgres
On Tue, Aug 5, 2014 at 12:32 PM, Andreas wrote:
> I then even tried to remove the local repository and install PG 9.1.
> That doesn't work either now. Same problem with the socket.
> Is there a way to get a working PG9.3 on a Rasberry?
This seems like a problem inherent to your OS or your RPMs as
Hi,
how can I get a working PG 9.3 for a RaspberryPI (Debian Wheezy)?
In the Raspian repository is only a V9.1 and the Debian repo of
postgresql.org has no ARM binaries.
I found a howto that describes how to fetch the source from
postgresql.org, compile it and set up a local repository with th
i think you could try pg_basebackup tools. it has options to achieve same
thing as you wanted. but need pgdata on destination emptied. if you really
need to do the exact thing as you stated, then you need to set postgres to
keep high enough number of xlog files on master to ensure that needed xlog
On Mon, Aug 4, 2014 at 3:48 PM, Jon Rosebaugh [via PostgreSQL] <
ml-node+s1045698n5813736...@n5.nabble.com> wrote:
> On Mon, Aug 4, 2014, at 06:40 PM, Jon Rosebaugh wrote:
>
> > On Tue, Jul 29, 2014, at 05:38 PM, David G Johnston wrote:
> > > You should at least provide some explain a/o explain an
On Mon, Aug 4, 2014, at 06:40 PM, Jon Rosebaugh wrote:
> On Tue, Jul 29, 2014, at 05:38 PM, David G Johnston wrote:
> > You should at least provide some explain a/o explain analyse results.
> >
> > Not to sound pedantic here but you are not JOINing on the CTE, you are
> > pushing it into WHERE cla
On Tue, Jul 29, 2014, at 05:38 PM, David G Johnston wrote:
> You should at least provide some explain a/o explain analyse results.
>
> Not to sound pedantic here but you are not JOINing on the CTE, you are
> pushing it into WHERE clause via a pair of sub-selects.
Fair criticisms. Okay, here we go
On Wed, Jul 16, 2014 at 02:39:03PM -0700, Jeff Janes wrote:
> On Wed, Jul 16, 2014 at 1:21 PM, Thomas Kellerer wrote:
>
> Hi,
>
> I was reading trough the ToDo list in the Postgres Wiki and noticed that
> one item for Fsync[1] seems to be obsolete:
>
> Determine optimal fdata
Or...
Do you mean to use windowing functions?
http://www.postgresql.org/docs/9.3/static/tutorial-window.html
Or both of course...
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
2014-08-04 19:43 GMT+02:00 Serge Fonville :
> Hi,
>
> Perhaps a CTE would help?
>
Hi,
Perhaps a CTE would help?
WITH NormCTE AS (
SELECT
delta - avg(delta))/stddev(delta) AS deltaNorm
, (echo - avg(echo))/stddev(echo) AS echoNorm
, (foxtrot - avg(foxtrot))/stddev(foxtrot) AS foxtrotNorm
FROM t_subs
)
SELECT
deltaNorm + echoNorm + foxtrotNorm AS
Hi,
I'm on Postgres 9.3.5, however I think my knowledge of Postgres is not deep
enough to help me with this challenge, so here I am reaching out to the
community !
Let's say I have a table as follows :
create table t_subs (alpha text,bravo text,charlie numeric,delta numeric,echo
numeric,foxtr
Hello,
How to improve performence of postgres 9.3 database.And also in
oracle web based Enterprise manger is available,in postgres any tool their
to monitor and change.
please let me know performence related info to my postgres 9.3
database.and any tools which are free and pay.
thanks,
Hi,
I’m missing a PG_RETURN_UINT16 macro. As we have PG_RETURN_UINT32 and also
PG_GETARG_UINT16 is there any reason why there is no PG_RETURN_UINT16 ?
cheers
Manuel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postg
On Mon, Jun 23, 2014 at 09:28:06PM -0500, Rene Romero Benavides wrote:
> It depends on the database transactional activity,
> observe how many new wal files are generated during a period equivalent to
> what
> it takes to do your base backup. I would set it to twice that number. Take
> into
> acc
Hi Asif,
Is it always creating core files on /var/lib/postgresql/8.4/main path for
ubontu?
i.e. in data directory.
Regards
Tarkeshwar
From: Asif Naeem [mailto:anaeem...@gmail.com]
Sent: 04 August 2014 16:01
To: M Tarkeshwar Rao
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Where the c
Hi Tarkeshwar,
If you are using Unix/Linux following link might be useful to you i.e.
https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD#Enabling_core_dumps
Regards,
Muhammad Asif Naeem
On Mon, Aug 4, 2014 at 3:19 PM, M Tarkeshwar Rao <
m.tarkesh
Hi all,
I want to know the exact path of the core files generated by Postgres server
during crash?
Can I configure it or generate it?
Regards
Tarkeshwar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailp
19 matches
Mail list logo
