Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems

On 6/25/19 2:27 AM, Kevin Brannen wrote: From: Tom Lane Brent Bates writes: I found the problem. I cleared everything out and started from scratch, then slowly added my changes back to the configuration files. The problem was in the postgresql.conf. At the bottom of the file I had

Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems

On 6/21/19 12:34 AM, Ian Barwick wrote: On 6/20/19 11:55 PM, Tom Lane wrote: Brent Bates writes:   I found the problem.  I cleared everything out and started from scratch, then slowly added my changes back to the configuration files.  The problem was in the postgresql.conf.  At the botto

Re: Tablespace column value null on select * from pg_tables

Hi Thomas and Adrian, I'm sorry on my part, you both are correct, thanks again for your help. What I did today that worked to move everything from data2 to pg_default was: 1. postgres=# ALTER DATABASE mydatabase SET TABLESPACE pg_default; ERROR: some relations of database "mydatabase" are alre

Re: Why no CREATE TEMP MATERIALIZED VIEW ?

> How different is a "*temp* materialized view" from a regular view? If it existed, it would be useful for cases when you need to reference that view in multiple queries in the same session. I've gotten around this by just using temp tables.

Re: Why no CREATE TEMP MATERIALIZED VIEW ?

On 7/16/19 11:56 AM, David G. Johnston wrote: On Tue, Jul 16, 2019 at 9:29 AM Ivan Voras > wrote: Out of curiosity, since there's CREATE TEMP VIEW, any particular reason there's no CREATE TEMP MATERIALIZED VIEW? Seems like it could be similar to a temp table

Re: Why no CREATE TEMP MATERIALIZED VIEW ?

On Tue, Jul 16, 2019 at 9:29 AM Ivan Voras wrote: > Out of curiosity, since there's CREATE TEMP VIEW, any particular reason > there's no CREATE TEMP MATERIALIZED VIEW? > > Seems like it could be similar to a temp table. > Probably a lack (absence) of use cases resulted in people deciding (or def

Why no CREATE TEMP MATERIALIZED VIEW ?

Hello, Out of curiosity, since there's CREATE TEMP VIEW, any particular reason there's no CREATE TEMP MATERIALIZED VIEW? Seems like it could be similar to a temp table.

Re: disable and enable trigger all when a foreign keys

Yeah, I understood, I have to do that, drop and re-add constraint to avoid issues.

Re: help understanding pgbench results

I've done another set of tests, and effectively it seems that, with unlogged tables, the checkpoint_completion_target does not influence the final results. I've increased the test duration in order to include several checkpoints within each run. First of all, initialization of the database: % pgbe

Re: How to run a task continuously in the background

On Tue, Jul 16, 2019 at 7:32 AM Dirk Mika wrote: > It's not really important that the job runs once a second, but that it starts > immediately when I want it to. > > If I start a job with pg_cron, it will not be executed until the next full > minute at the earliest. > > The processing of the dat