[GENERAL] Where should I post 3rd party product announcements?

Hello, I am the author of a database replication solution to which I recently added Postgres support. I would like to let the PG community know about it and I therefore posted a message to this list, but it didn't come through, presumably because it was considered to be spam. Where would be

Re: [GENERAL] Where should I post 3rd party product announcements?

On Tue, Oct 14, 2014 at 4:58 PM, Jonathan Neve wrote: > Hello, > > I am the author of a database replication solution to which I recently added > Postgres support. I would like to let the PG community know about it and I > therefore posted a message to this list, but it didn't come through, > pres

Re: [GENERAL] Where should I post 3rd party product announcements?

Hello Amit, I tried pg-announce as well, but my message didn't go through… Jonathan Le mardi 14 octobre 2014 11:38:02, Amit Langote a écrit : On Tue, Oct 14, 2014 at 4:58 PM, Jonathan Neve wrote: Hello, I am the author of a database replication solution to which I recently added Postgres su

Re: [GENERAL] Where should I post 3rd party product announcements?

On Tue, Oct 14, 2014 at 3:12 PM, Jonathan Neve wrote: > Hello Amit, > > I tried pg-announce as well, but my message didn't go through… > > Jonathan > > Le mardi 14 octobre 2014 11:38:02, Amit Langote a écrit : > > On Tue, Oct 14, 2014 at 4:58 PM, Jonathan Neve >> wrote: >> >>> Hello, >>> >>> I

Re: [GENERAL] Where should I post 3rd party product announcements?

On Tue, Oct 14, 2014 at 11:42 AM, Jonathan Neve wrote: > Hello Amit, > > I tried pg-announce as well, but my message didn't go through… Not having seen the actual post, it may have been moderated based on the rules at https://wiki.postgresql.org/wiki/NewsEventsApproval. These are primarily for we

Re: [GENERAL] Where should I post 3rd party product announcements?

Sorry for being a bit dense, but where should I submit a website news posting ? Le mardi 14 octobre 2014 11:45:55, Magnus Hagander a écrit : On Tue, Oct 14, 2014 at 11:42 AM, Jonathan Neve wrote: Hello Amit, I tried pg-announce as well, but my message didn't go through… Not having seen

Re: [GENERAL] Where should I post 3rd party product announcements?

It's on http://www.postgresql.org/, click the link that says "Submit news". //Magnus On Tue, Oct 14, 2014 at 11:55 AM, Jonathan Neve wrote: > Sorry for being a bit dense, but where should I submit a website news > posting ? > > Le mardi 14 octobre 2014 11:45:55, Magnus Hagander a écrit : >> >>

Re: [GENERAL] Where should I post 3rd party product announcements?

Thanks, I'll give that a try! Jonathan Le 14/10/14 12:01, Magnus Hagander a écrit : It's on http://www.postgresql.org/, click the link that says "Submit news". //Magnus On Tue, Oct 14, 2014 at 11:55 AM, Jonathan Neve wrote: Sorry for being a bit dense, but where should I submit a website ne

Re: [GENERAL] Optimal checkpoint_setting

Thank you for your answer, but I don't have access to this server any more and have to just interpret and pick some parameters from test results, but your advice about tar trick is something I'm gonna try for sure in next test. So, because I don't have any chance to do some more tests, should I ch

[GENERAL] Mailing list pgbr-geral

Brazilian users, The mailing list "pgbr-geral" has been discontinued?

[GENERAL] listen from slave database

Hi, I know I can't use "listen" from streaming slave database. >From the document ( http://www.postgresql.org/docs/9.3/static/hot-standby.html), (...Transactions started during hot standby will never be assigned a transaction ID and cannot write to the system write-ahead log. Therefore, the foll

Re: [GENERAL] Where should I post 3rd party product announcements?

> On Tue, Oct 14, 2014 at 3:12 PM, Jonathan Neve wrote: > > > I tried pg-announce as well, but my message didn't go through… The message is not in the moderation queue, so it must have been flagged as spam. Without having seen it, a priori I don't think it's completely inappropriate for pgsql-a

[GENERAL] copying a large database to change encoding

Would something like this work best, or is it better to use pgdump? CREATE DATABASE newDatabase TEMPLATE oldDatabase ENCODING 'UTF8' Does using a template do a file system copy or just SQL copy everything over? -Matt

Re: [GENERAL] copying a large database to change encoding

On 10/14/2014 10:31 AM, Matthew Chambers wrote: Would something like this work best, or is it better to use pgdump? CREATE DATABASE newDatabase TEMPLATE oldDatabase ENCODING 'UTF8' I actually just did that for a database. Does using a template do a file system copy or just SQL copy everyth

Re: [GENERAL] copying a large database to change encoding

Thanks, How long did it take to complete? On 15/10/14 06:39, Adrian Klaver wrote: On 10/14/2014 10:31 AM, Matthew Chambers wrote: Would something like this work best, or is it better to use pgdump? CREATE DATABASE newDatabase TEMPLATE oldDatabase ENCODING 'UTF8' I actually just did that fo

Re: [GENERAL] copying a large database to change encoding

On 10/14/2014 10:43 AM, Matthew Chambers wrote: Thanks, How long did it take to complete? I did not time that copy. I just tried with a small database(76 MB on disk) and it took 27 secs. This is using Linux on an older(3 yrs+) i386 machine. -- Adrian Klaver adrian.kla...@aklaver.com --

Re: [GENERAL] copying a large database to change encoding

It should take about as much time as cp -r of the directory for that DB would take. On Tue, Oct 14, 2014 at 1:58 PM, Adrian Klaver wrote: > On 10/14/2014 10:43 AM, Matthew Chambers wrote: >> >> Thanks, >> >> How long did it take to complete? >> > > I did not time that copy. I just tried with a s

[GENERAL] Will pg_repack improve this query performance?

I believe this query is well optimized, but it's slow if the all the blocks aren't already in memory. Here's example explain output. You can see it takes over 7 seconds to run when it needs to hit the disk, and almost all of it is related to checking if the user has "messages." http://explain.d