Re: Parallel copy

On 2/15/20 7:32 AM, Amit Kapila wrote: > On Sat, Feb 15, 2020 at 4:08 PM Alastair Turner wrote: >> On Sat, 15 Feb 2020 at 04:55, Amit Kapila wrote: >>> On Fri, Feb 14, 2020 at 7:16 PM Alastair Turner wrote: >> ... Parsing rows from the raw input (the work done by CopyReadLine()) in a

Re: jsonb_object() seems to be buggy. jsonb_build_object() is good.

On 2/15/20 12:06 AM, Bryn Llewellyn wrote: > Thank you both, Vik, and David, for bing so quick to respond. All is > clear now. It seems to me that the price (giving up the ability to say > explicitly what primitive JSON values you want) is too great to pay > for the benefit (being able to build

Re: pgsql: walreceiver uses a temporary replication slot by default

On Wed, Jan 22, 2020 at 06:58:46PM +0300, Sergei Kornilov wrote: > I would like to cross-post here a patch with such changes that I posted in > "allow online change primary_conninfo" thread. > This thread is more appropriate for discussion about > wal_receiver_create_temp_slot. > > PS: I posted

Re: New messages from Priscilla Ip

Hi, Feel free to send out the email blast. There are a number of other channels. postgres slack, postgres mailing lists, @PostgreSQL Hackers , twitter with Postgres tag Cheers, Dave Cramer On Sat, 15 Feb 2020 at 19:44, 'Meetup Messages' via Meetup < mee...@postgresql.us> wrote: > ~~~

Re: explain HashAggregate to report bucket and memory stats

On Mon, Feb 03, 2020 at 06:53:01AM -0800, Andres Freund wrote: > On 2020-01-03 10:19:26 -0600, Justin Pryzby wrote: > > On Sun, Feb 17, 2019 at 11:29:56AM -0500, Jeff Janes wrote: > > https://www.postgresql.org/message-id/CAMkU%3D1zBJNVo2DGYBgLJqpu8fyjCE_ys%2Bmsr6pOEoiwA7y5jrA%40mail.gmail.com > >

Re: Just for fun: Postgres 20?

On Fri, Feb 14, 2020 at 7:19 PM Tom Lane wrote: > > Andrew Dunstan writes: > > I also object because 20 is *my* unlucky number ... > > Not sure how serious Andrew is being here, but it does open up an > important point: there are varying opinions on which numbers are unlucky. > The idea that 13

Re: assert pg_class.relnatts is consistent

I wrote: > So that leads me to the attached. > ... > (I agree with Alvaro's thought of shortening AddDefaultValues, > but didn't do that here.) Pushed both of those. I also did something with the stale comment that Justin referred to in the initial message (it wasn't really good practice to try

Re: Use LN_S instead of "ln -s" in Makefile

Andreas Karlsson writes: > On 2/15/20 1:57 AM, Tom Lane wrote: >> Hm. So, these oversights are certainly bugs in narrow terms. However, >> they've all been like that for a *long* time --- the three instances >> you found date to 2005, 2006, and 2008 according to "git blame". >> The complete

Re: Parallel copy

On Sat, Feb 15, 2020 at 06:02:06PM +0530, Amit Kapila wrote: > On Sat, Feb 15, 2020 at 4:08 PM Alastair Turner wrote: > > > > On Sat, 15 Feb 2020 at 04:55, Amit Kapila wrote: > > > > > > On Fri, Feb 14, 2020 at 7:16 PM Alastair Turner > > > wrote: > > > > > > ... > > > > > > > > Parsing rows

Re: Use LN_S instead of "ln -s" in Makefile

On 2/15/20 1:57 AM, Tom Lane wrote: Hm. So, these oversights are certainly bugs in narrow terms. However, they've all been like that for a *long* time --- the three instances you found date to 2005, 2006, and 2008 according to "git blame". The complete lack of complaints shows that nobody

Re: Parallel copy

On Sat, Feb 15, 2020 at 4:08 PM Alastair Turner wrote: > > On Sat, 15 Feb 2020 at 04:55, Amit Kapila wrote: > > > > On Fri, Feb 14, 2020 at 7:16 PM Alastair Turner wrote: > > > > ... > > > > > > Parsing rows from the raw input (the work done by CopyReadLine()) in a > > > single process would

Re: Parallel copy

On Sat, 15 Feb 2020 at 04:55, Amit Kapila wrote: > > On Fri, Feb 14, 2020 at 7:16 PM Alastair Turner wrote: > > ... > > > > Parsing rows from the raw input (the work done by CopyReadLine()) in a > > single process would accommodate line returns in quoted fields. I don't > > think there's a way

Re: [Proposal] Global temporary tables

> postgres=# insert into foo select generate_series(1,1); > INSERT 0 1 > postgres=# \dt+ foo > List of relations > ┌┬──┬───┬───┬─┬┬─┐ > │ Schema │ Name │ Type │ Owner │ Persistence │ Size │ Description │ >

Re: [Proposal] Global temporary tables

> 2020年2月14日 下午5:19，Pavel Stehule 写道： > > > > čt 30. 1. 2020 v 15:21 odesílatel Pavel Stehule > napsal: > > > čt 30. 1. 2020 v 15:17 odesílatel 曾文旌(义从) > napsal: > > > > 2020年1月29日 下午9:48，Robert Haas >

Re: proposal: schema variables

001 patch) > rebase Pavel > Regards > > Pavel > 0001-schema-variables-20200215.patch.gz Description: application/gzip