On 2/13/20 9:02 PM, Adrian Klaver wrote:
On 2/13/20 7:54 PM, Jason Swails wrote:
Hi,
I've been struggling with a strange (to me) issue for awhile. I have
PostgreSQL 11.6 installed on my Ubuntu machine with the data directory
living on a different drive than the one mounted on /. I was observ
On 2/13/20 7:54 PM, Jason Swails wrote:
Hi,
I've been struggling with a strange (to me) issue for awhile. I have
PostgreSQL 11.6 installed on my Ubuntu machine with the data directory
living on a different drive than the one mounted on /. I was observing
the same behavior when my machine was
Hi,
I've been struggling with a strange (to me) issue for awhile. I have
PostgreSQL 11.6 installed on my Ubuntu machine with the data directory
living on a different drive than the one mounted on /. I was observing the
same behavior when my machine was running Gentoo a month ago.
The problem is
>What is your concern, storage space or performance of queries?
>If performance then an EXPLAIN ANALYZE on a query will help show whether there
>is an issue or not.
@Adrian Klaver I guess I am after both, I would like to squeeze the most
performance out of my tables and installation as possible
On 2/13/20 12:45 PM, Jason Ralph wrote:
@Adrian Klaver,
I was concerned with the 1.4 value of tbloat and wastedbytes value, then again
the last autovacuum was at 2020-02-13 02:25:22.533372-05 and I took this
snapshot at 3:44PMEST. So it may be ok, what do you think?
What is your concern, sto
@Adrian Klaver,
I was concerned with the 1.4 value of tbloat and wastedbytes value, then again
the last autovacuum was at 2020-02-13 02:25:22.533372-05 and I took this
snapshot at 3:44PMEST. So it may be ok, what do you think?
current_database | schemaname | tablename
On 2/13/20 11:07 AM, Jason Ralph wrote:
>There is more than one type of statistics though. Stats on the
distribution of data is easily recreated with analyze table_name or
analyzing the whole >database. What about the stats on how many rows
have been inserted or updated since the last (auto)va
>There is more than one type of statistics though. Stats on the distribution of
>data is easily recreated with analyze table_name or analyzing the whole
>>database. What about the stats on how many rows have been inserted or updated
>since the last (auto)vacuum and that will be used to trigger a
On 2/13/20 10:04 AM, Jason Ralph wrote:
Well table bloat and table statistics are two different things. Bloat is the
accumulation of dead or potentially dead tuples whose space has not been marked
> as available for reuse by VACUUM or whose space has been returned to the OS
with VACUUM FULL.
>Well table bloat and table statistics are two different things. Bloat is the
>accumulation of dead or potentially dead tuples whose space has not been
>marked > as available for reuse by VACUUM or whose space has been returned to
>the OS with VACUUM FULL. For more information see:
Thanks for
There is more than one type of statistics though. Stats on the distribution
of data is easily recreated with analyze table_name or analyzing the whole
database. What about the stats on how many rows have been inserted or
updated since the last (auto)vacuum and that will be used to trigger
autovacuu
On 2/13/20 4:31 AM, Jason Ralph wrote:
When using the pg_upgrade link method to upgrade Postgres a major
version. Let’s say 9.3 to 11.6 on Centos Linux. Will table bloat carry
over to the new version. I know using —link will use hard link pointers
to the new data. So I assume all table bloat wi
It works.
Thank you, thank you, thank you.
-- Original Message --
From: "Julien Rouhaud"
To: "Sterpu Victor"
Cc: pgsql-gene...@postgresql.org
Sent: 2020-02-13 3:48:08 PM
Subject: Re: Enabling extensions on a compiled instance of postgresql
12.1
On Thu, Feb 13, 2020 at 01:34:55PM +00
On Thu, Feb 13, 2020 at 01:34:55PM +, Sterpu Victor wrote:
> Hello
>
> I compiled from source postgresql 12.1 and all went fine but when I try to
> restore my DB I can see that I have 3 extensions missing: uuid-ossp,
> btree_gist, tablefunc.
> I tried to run: CREATE EXTENSION "uuid-ossp"; and t
Hello
I compiled from source postgresql 12.1 and all went fine but when I try
to restore my DB I can see that I have 3 extensions missing: uuid-ossp,
btree_gist, tablefunc.
I tried to run: CREATE EXTENSION "uuid-ossp"; and the error is ERROR:
could not open extension control file
"/usr/local
That looks very useful indeed. Thanks Tomas
On Wed, Feb 12, 2020 at 8:32 PM Tomas Vondra
wrote:
> On Wed, Feb 12, 2020 at 10:23:22AM -0700, Michael Lewis wrote:
> >It may also be worth noting that it is possible to make autovacuum/analyze
> >more aggressive, perhaps only on the tables that see l
When using the pg_upgrade link method to upgrade Postgres a major version.
Let’s say 9.3 to 11.6 on Centos Linux. Will table bloat carry over to the new
version. I know using —link will use hard link pointers to the new data. So I
assume all table bloat will carry over to the new version. I also
On Wed, Feb 12, 2020 at 4:09 PM Tom Lane wrote:
> =?UTF-8?Q?Mladen_Marinovi=C4=87?= writes:
> > Recently I am having some strange problems with pg_basebackup. About
> once a
> > week the backup process ends with an error message like this:
> > 2020-02-11 23:25:40 UTC [25790]: [1-1] user=replicat
18 matches
Mail list logo
