On Wed, Jun 10, 2015 at 6:47 PM, wrote:
Is it normal that pg_basebackup runs successfully (rc=0) and there is no
> WAL files present?
>
Yes, it is normal. "pg_basebackup" ensures that required WALs are backed
along with the data directory. This is to ensure backup is consistent.
> The master a
On Mon, Jun 08, 2015 at 03:15:04PM +0200, Andres Freund wrote:
> One more thing:
> Our testing infrastructure sucks. Without writing C code it's basically
> impossible to test wraparounds and such. Even if not particularly useful
> for non-devs, I really think we should have functions for creating
Here is a follow-up on adjusting the planner costs calculation
-Statistics target of problematic columns were increased from 100 to 200.
-Analyse was ran on all concerned tables (actually ran on the whole DB)
-Random_page_cost was decreased from 4 to 2.
As a result, about 80% of queries are now u
Nicolas Paris wrote:
> Would views + partial indexes (based on views predicat) do the trick ?
I don't see anything promising that way, but feel free to work up a
proof of concept patch if you do.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent v
2015-06-10 17:43 GMT+02:00 Kevin Grittner :
> inspector morse wrote:
>
> > After doing that, if you add or delete a topic from the Topics
> > Table, SQL Server automatically keeps the count updated.and
> > it's fast because of the unique index.
> >
> > Doing the same thing in Postgresql using
inspector morse wrote:
> After doing that, if you add or delete a topic from the Topics
> Table, SQL Server automatically keeps the count updated.and
> it's fast because of the unique index.
>
> Doing the same thing in Postgresql using Materialized views is
> slow and the developer has to man
I have been testing a master slave configuration of PostgreSQL 9.4.2 using
streaming replciation. The master is initialised with a blank database and
the slave is created with a pg_start_backup()/rsync/pg_stop_backup()
procedure. The slave connects to the master and works flawlessly. For
testing pu
