On Thu, May 19, 2016 at 05:52:26PM -0400, Tom Lane wrote:
> "k...@rice.edu" writes:
> > The stack trace just appeared to be what I would expect while a 'DISCARD
> > ALL'
> > command was being run:
>
> > #0 0x0073bc7c in Memor
On Thu, May 19, 2016 at 09:58:45AM -0400, Tom Lane wrote:
> "k...@rice.edu" writes:
> > I am investigating a problem with a backend that appears to be stuck
> > and spinning while performing a "DISCARD ALL" command. The system is
> > running an older re
On Thu, May 19, 2016 at 09:58:45AM -0400, Tom Lane wrote:
> "k...@rice.edu" writes:
> > I am investigating a problem with a backend that appears to be stuck
> > and spinning while performing a "DISCARD ALL" command. The system is
> > running an older re
Hi PostgreSQL community,
I am investigating a problem with a backend that appears to be stuck
and spinning while performing a "DISCARD ALL" command. The system is
running an older release 9.2.2. Are there any bugs that could be
causing this behavior? How can I tell what the process is actually
doi
On Thu, Jun 18, 2015 at 07:19:13PM +, Sheena, Prabhjot wrote:
> Hi Ken/ Will
>
> I have checked the ulimit value and we are nowhere hitting the max 4096
> that we have currently set. Is there any other explanation why we should be
> thinking of bumping it to like ulimit -n 5000
On Thu, Jun 18, 2015 at 05:41:01PM +, Sheena, Prabhjot wrote:
> Here is the output of OS limits
>
> postgres@symds-pg:~ $ ulimit -a
>
> core file size (blocks, -c) 0
> data seg size (kbytes, -d) unlimited
> scheduling priority (-e) 0
> file size (b
On Thu, Jun 18, 2015 at 05:09:10PM +, Sheena, Prabhjot wrote:
> Guys
> I have an issue going on with PGBOUNCER which is slowing down the
> site
>
> PGBOUNCER VERSION: pgbouncer-1.5.4-2.el6 (Hosted on separate machine) (16
> cpu) 98GB RAM
> DATABASE VERION: postgresql 9.3
>
On Fri, Jun 12, 2015 at 09:37:36PM +, Sheena, Prabhjot wrote:
> Here is some more information
>
> pool_mode | transaction
>
> We have transactional pooling and our application is set up in such a way
> that we have one query per transaction. We have set default pool size to
On Fri, Jan 23, 2015 at 01:56:53PM -0600, Suresh Raja wrote:
> Hi All:
>
> We are running a function with a loop in it. We tried
> commit;
> We are getting error with above command. How can i easily commit withing
> a function.
>
>
> Thanks,
> -SR
PostgreSQL functions run within a transaction
On Mon, Feb 25, 2013 at 01:57:11PM -0500, Frank Cavaliero wrote:
> Hi Adrian,
>
> Thanks for the response. The situation is more like the following:
>
> Using the JDBC driver, I connect to database TEST1 and immediately,
> without having to pass username credentials again, I want to use databa
On Mon, Aug 01, 2011 at 04:42:23PM +0200, Willy-Bas Loos wrote:
> Hi,
>
> I'ver been wondering how to set the number of rows that are scanned by
> analyze. (I want to increase it)
> I couln't find it at first but when i read closer i found that is does:
> "The largest statistics target among the c
11 matches
Mail list logo
