On Fri, 21 Oct 2016 14:29:24 +0900
Michael Paquier wrote:
> That's invasive. I am wondering if a cleaner approach here would be a
> flag in deleteOneObject() that performs the lock cleanup, as that's
> what you are trying to solve here.
The problem occurs earlier, at the findDependentObjects ste
On Mon, 5 Sep 2016 14:54:05 +0300
Grigory Smolkin wrote:
> Hello, hackers!
>
> We were testing how well some application works with PostgreSQL and
> stumbled upon an autovacuum behavior which I fail to understand.
> Application in question have a habit to heavily use temporary tables
> in funny
On Wed, 31 Aug 2016 14:46:30 +0100
Greg Stark wrote:
> On Wed, Aug 31, 2016 at 2:50 AM, Peter Eisentraut
> wrote:
> > - A API interface to open a "connection" to a background worker, run
> > queries, get results: AutonomousSessionStart(),
> > AutonomousSessionEnd(), AutonomousSessionExecute(), e
Here is a new version of the patch, which:
1. Fixes some minor stylistic issues.
2. Uses binaryheap (instead of a custom ugly stack) for merging.
Regards,
Constantin S. Pan
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
diff --git a/doc/src/sgml/config.sgml b
ck! Fixed all of these in the new
version. Also added new queries to 'gin' regression test, which
immediately helped me catch one silly bug. The new patch is
attached.
Regards,
Constantin S. Pan
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Companydiff --git a/
On Fri, 18 Mar 2016 20:40:16 +0300
Dmitry Ivanov wrote:
> Hi Constantin,
>
> I did a quick review of your patch, and here are my comments:
>
> - This patch applies cleanly to the current HEAD (61d2ebdbf91).
>
> - Code compiles without warnings.
>
> - Currently there's no documentation regardi
On Thu, 17 Mar 2016 13:21:32 +0530
Amit Kapila wrote:
> On Wed, Mar 16, 2016 at 7:50 PM, Constantin S. Pan
> wrote:
> >
> > On Wed, 16 Mar 2016 18:08:38 +0530
> > Amit Kapila wrote:
> >
> > >
> > > Why backend just waits, why can't it doe
On Wed, 16 Mar 2016 18:08:38 +0530
Amit Kapila wrote:
> On Wed, Mar 16, 2016 at 2:55 PM, Constantin S. Pan
> wrote:
> >
> > On Wed, 16 Mar 2016 12:14:51 +0530
> > Amit Kapila wrote:
> >
> > > On Wed, Mar 16, 2016 at 5:41 AM, Constantin S. Pan
> >
On Wed, 16 Mar 2016 02:43:47 -0700
Peter Geoghegan wrote:
> On Wed, Mar 16, 2016 at 2:25 AM, Constantin S. Pan
> wrote:
> > The backend just waits for the results from the workers and merges
> > them (in case wnum > 0). So the 1-worker configuration should never
> >
On Wed, 16 Mar 2016 12:14:51 +0530
Amit Kapila wrote:
> On Wed, Mar 16, 2016 at 5:41 AM, Constantin S. Pan
> wrote:
>
> > On Mon, 14 Mar 2016 08:42:26 -0400
> > David Steele wrote:
> >
> > > On 2/18/16 10:10 AM, Constantin S. Pan wrote:
> > > >
On Mon, 14 Mar 2016 08:42:26 -0400
David Steele wrote:
> On 2/18/16 10:10 AM, Constantin S. Pan wrote:
> > On Wed, 17 Feb 2016 23:01:47 +0300
> > Oleg Bartunov wrote:
> >
> >> My feedback is (Mac OS X 10.11.3)
> >>
> >> set gin_parallel_workers=2
On Wed, 17 Feb 2016 23:01:47 +0300
Oleg Bartunov wrote:
> My feedback is (Mac OS X 10.11.3)
>
> set gin_parallel_workers=2;
> create index message_body_idx on messages using gin(body_tsvector);
> LOG: worker process: parallel worker for PID 5689 (PID 6906) was
> terminated by signal 11: Segment
AM, Constantin S. Pan
> wrote:
> > 4. Hit the 8x speedup limit. Made some analysis of the reasons (see
> > the attached plot or the data file).
>
> Did you actually compare this to the master branch? I wouldn't like to
> assume that the one worker case was equivalen
On Sat, 16 Jan 2016 01:38:39 +0300
"Constantin S. Pan" wrote:
> The task of building GIN can require lots of time and eats 100 % CPU,
> but we could easily make it use more than a 100 %, especially since we
> now have parallel workers in postgres.
>
> The process of bui
On Fri, 15 Jan 2016 15:29:51 -0800
Peter Geoghegan wrote:
> On Fri, Jan 15, 2016 at 2:38 PM, Constantin S. Pan
> wrote:
> Even without parallelism, wouldn't it be better if GIN indexes were
> built using tuplesort? I know way way less about the gin am than the
> nbtree am,
which the parallel mode does not work.
Please leave your feedback.
Regards,
Constantin S. Pan
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
diff --git a/src/backend/access/gin/gininsert.c b/src/backend/access/gin/gininsert.c
index 8bcd159..6ea8f78 100644
--- a/src
16 matches
Mail list logo
