>
> I see. But in my case rows don't reach that thresold (I didn't check if
>> 2K but I didn't change anything). So I'm wondering if there is any other
>> chance except the TOAST to get the rows compressed or not.
>>
>
> Are you really sure you want that? For small files the overhead of
> compressi
Hi,
I enabled data checksums (initdb --data-checksums) on a new instance and
was wandering is there a command in the psql console, or from the linux
console, to force a checksum check on the entire cluster and get error
reports if it finds some corrupted pages.
Regards,
Mladen Marinović
--
[re-post, originally sent with wrong username]
On Thu, 15 Dec 2016 16:42:13 + (GMT)
Richard Brosnahan wrote:
>
> I get a checksum error, from pg_ctl.
> 2016-12-15 08:27:14.520 PST >FATAL: incorrect checksum in control file
>
Hi Richard,
Not sure if it applies, but just in case, I got th
Does anyone have experience using pg_repack on Postgres versions > 9.4?
Specifically 9.5, but probably 9.6 at some point.
The documentation claims it supports up to 9.4. I haven't looked at it
closely enough to guess whether there might be changes in 9.5/9.6 to
cause it not to work any more.
Any
On Fri, Dec 16, 2016 at 09:15:51AM -0500, Bill Moran wrote:
>
> Does anyone have experience using pg_repack on Postgres versions > 9.4?
> Specifically 9.5, but probably 9.6 at some point.
>
> The documentation claims it supports up to 9.4. I haven't looked at it
> closely enough to guess whether
On 12/16/2016 01:02 AM, Simon Charette wrote:
> Unfortunately this will only return accounts matching the current_user's name.
>
> I would expect "SET ROLE foo; SELECT name FROM accounts" to return "foo" and
> "bar" and not only "foo" like your proposed solution would do.
Perhaps:
8<
Hey Folks,
we use postgres from the actual RHEL 7 repo.I installed it some weeks ago and
changed the user/group under which the service
runs via systemd:userdel postgresgroupdel postgreschown newuser.newgroup
/var/run/postgresql -Rchown newuser.newgroup /var/lib/pgsql -R systemctl edit
postgr
On 12/16/2016 12:23 AM, Tom DalPozzo wrote:
I see. But in my case rows don't reach that thresold (I didn't
check if
2K but I didn't change anything). So I'm wondering if there is
any other
chance except the TOAST to get the rows compressed or not.
Are
Depends on goals of your benchmarking.
What are you trying to achieve?
Initialization and vacuuming each time will help achieve more consistent
best-case numbers (to reduce variance, I'd also destroy cluster completely
and clean up hardware, e.g. run fstrim in case of SSD, etc).
If you are howeve
We run a master server and a hot standby server. Reporting users login to
the standby server to run long queries. However, their login is also valid
on the master server. Is it possible to prevent a user from logging in to
the master server?
A statement like:
alter role newbie_business_
On Fri, Dec 16, 2016 at 9:17 AM, Andomar wrote:
> We run a master server and a hot standby server. Reporting users login to
> the standby server to run long queries. However, their login is also valid
> on the master server. Is it possible to prevent a user from logging in to
> the master server?
>
> We run a master server and a hot standby server. Reporting users login to
> the standby server to run long queries. However, their login is also valid
> on the master server. Is it possible to prevent a user from logging in to
> the master server?
>
What I do is use roles as groups, and create
"Andomar" writes:
> We run a master server and a hot standby server. Reporting users login to
> the standby server to run long queries. However, their login is also valid
> on the master server. Is it possible to prevent a user from logging in to
> the master server?
You could use different pg_hb
> Two questions:
>
> 1) Do you know what your data in the future is going to be?
>
> 2) Is a 100 byte bytea a realistic approximation of that data?
>
> wal_compression=off.
>>
>> --
> Adrian Klaver
> adrian.kla...@aklaver.com
Hi,
1) not precisely, but 10/100 million insertions per day. I can't k
I believe a lot of application programmers, particularly but by no means
limited to web application developers, have a tragic prejudice against treating
their database as anything but a dumb data bucket.
They also often lack awareness of even simple-to-use SQL/Postgres features that
would make
Guyren Howe writes:
> I believe a lot of application programmers, particularly but by no means
> limited to web application developers, have a tragic prejudice against
> treating their database as anything but a dumb data bucket.
> They also often lack awareness of even simple-to-use SQL/Postgre
On Dec 16, 2016, at 16:52 , Tom Lane wrote:
>
>> So I’ve started a project to fix this. I’m initially going to write a series
>> of blog posts demonstrating in principle how a developer can put much/all of
>> their model logic in their database.
>
> Cool. This sounds well worth while.
Thanks
Hi,
I am using Postgresql 9.5.
Below is the sample data taken from the mail table with only required columns:
id | question_id | answer_id | content
+-+---+--
2 | 25 | 270 | Arup
3 | 26 | 276 | Kajal
4 | 26 | 276 | Arup
Hello
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Arup Rakshit
> Sent: Samstag, 17. Dezember 2016 08:39
> To: Pgsql-general
> Subject: [GENERAL] Delete from table conditionally
>
> Hi,
>
> I am using Postgre
19 matches
Mail list logo
