null
Cheers,
Chris Sterritt
ck plan to use
excel with pages linked to views in the database but i'm looking for
something a little more targeted.
does anyone have any suggestions that fit the description above?
thanks for any input,
chris
I'm trying to create a visual representation of a 6x8 grid of samples on a
rack using the following SQL format:
with rack_display as (
select sr.ts rack_ts
, sr.rack_id
, r.rack_barcode
, 1 as row_pos
, max(case when rack_well = 0 then 'A1: '||sample_barcode end
this would cause decreased performance when used with
tables with a lot of writes and deletes. Is there a technical reason this
setting cannot be applied at the database or table context like other
autovacuum settings?
- chris
On Wed, Apr 6, 2022 at 6:24 PM Adrian Klaver
wrote:
> On 4/6/22 3:13 PM, Chris Bisnett wrote:
> > Hi all!
> >
> > I have several large tables (1-2Tb) that are 99.9% writes (small number
> > of updates) with a decent commit rate (20K/sec). The basic idea is that
> &
On Wed, Apr 6, 2022 at 6:31 PM Adrian Klaver
wrote:
> On 4/6/22 3:28 PM, Chris Bisnett wrote:
> > On Wed, Apr 6, 2022 at 6:24 PM Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote:
>
> >
> > It can:
> >
> >
> https://www.p
CCESS
SHARED locks have to be taken on all tables as well as all associated
resources (indexes, sequences, etc.) and the act of taking and
releasing all of those locks will increase the lock contention
significantly. We're working to update our application so that we can
take advantage of the pruning. Are you also using native partitioning?
- Chris
Hi,
I have a postgresql server version 12.9 and trying to upgrade it to 14.5.
My OS is Centos 8 Stream and I already managed to install postgresql14.5
but when I'm trying to upgrade, I am encountering this error
bash-4.4$ /usr/pgsql-14/bin/pg_upgrade
--old-datadir=/home/dmartuser/pgdata/data/
--n
sses=''
-c unix_socket_permissions=0700 -c unix_socket_directories='/tmp'" start
Failure, exiting
Thanks,
Chris Albert Navarroza
Information Technology Officer I
CTCO - ITDS - RDMD
On Fri, Oct 21, 2022 at 10:08 PM Tom Lane wrote:
> chris navarroza writes:
>
4), 64-bit
2022-10-24 07:41:13.460 PST [107444] LOG: listening on Unix socket
"/tmp/.s.PGSQL.50432"
2022-10-24 07:41:13.486 PST [107444] LOG: redirecting log output to
logging collector process
2022-10-24 07:41:13.486 PST [107444] HINT: Future log output will appear
in directory "lo
us=1
Oct 24 15:16:45 datamartds systemd[1]: postgresql-14.service: Failed with
result 'exit-code'.
How can I point the service to read the new path (
/home/dmartuser/pgsql/14/data )?
Thanks,
Chris Albert Navarroza
Information Technology Officer I
CTCO - ITDS - RDMD
But I'm using a different path when I initdb /usr/pgsql-14/bin/initdb
-D */home/dmartuser/pgsql/14/data
*so "/var/lib/pgsql/14/data/" is really empty. Is there a way to point the
startup script to the new path */home/dmartuser/pgsql/14/data* ?
Thanks,
Chris Albert Navarr
I fixed it by editing the postgresql-14.service PGDATA path to the new
directory
Thanks,
butching
On Mon, Oct 24, 2022 at 7:25 PM chris navarroza
wrote:
> But I'm using a different path when I initdb /usr/pgsql-14/bin/initdb -D
> */home/dmartuser/pgsql/14/data
> *so "/va
Hi,
Ive created a read only user (SELECT PRIVILEGE) but it turns out that this
user can do this queries: SHOW work_mem; SET work_mem='40MB'; How do I
limit him?
Thanks,
Butching
The latest entry is at:
https://www.timescale.com/blog/a-postgresql-developers-perspective-five-interesting-patches-from-januarys-commitfest/?utm_source=timescaledb&utm_medium=linkedin&utm_campaign=mar-2023-advocacy&utm_content=tsdb-blog
--
Best Wishes,
Chris Travers
; --
>
> Thanks and Regards,
> Sachin Kotwal
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
pm package postgresql10-server-10.6-1PGDG.rhel7.x86_64
error: unpacking of archive failed: cpio: lstat
(full output below)
I'm a bit at loss here... I'd interpret the message towards a corrupted
package (?).
Has anybody seen something like this?
Thanks,
Bye,
Chris.
# yum u
ely to make such a difference? We're currently on 9.4, is
this something that's likely to be different (better? worse?) if we got
all the way up to 10 or 11?
cheers,
Chris
On 28/11/2018 22:49, Stephen Frost wrote:
* Chris Withers (ch...@withers.org) wrote:
We have an app that deals with a lot of queries, and we've been slowly
seeing performance issues emerge. We take a lot of free form queries from
users and stumbled upon a very surprising optimisation.
S
ending up being a big scan rather than some quick
lookups based on the index?
cheers,
Chris
an then further optimize by
doing analyze only on the changed tables.
Bye,
Chris.
We're kind of pulling out our hair here, any ideas?
You might try issuing the command
analyze;
right *before* the command that hangs.
Clarification: I meant to say: "put it into the script at the location right before
the command, that hangs".
Bye,
Chris.
On 30/11/2018 15:33, Stephen Frost wrote:
Greetings,
* Chris Withers (ch...@withers.org) wrote:
On 28/11/2018 22:49, Stephen Frost wrote:
* Chris Withers (ch...@withers.org) wrote:
We have an app that deals with a lot of queries, and we've been slowly
seeing performance issues emerg
hough I've
set effective_cache_size to 200GB, I only see 9G of memory being used.
How can I persuade postgres to keep more in memory?
cheers,
Chris
ot; SET ...bunch of fields... WHERE
"alerts_alert"."id" = '...sha1 hash...';
Here's a sample explain:
https://explain.depesz.com/s/Fjq8
What could be causing this? What could we do to debug? What config
changes could we make to alleviate this?
cheers,
Chris
On 05/12/2018 14:38, Stephen Frost wrote:
Greetings,
* Chris Withers (ch...@withers.org) wrote:
On 30/11/2018 15:33, Stephen Frost wrote:
* Chris Withers (ch...@withers.org) wrote:
On 28/11/2018 22:49, Stephen Frost wrote:
For this, specifically, it's because you end up with exactly
one for another while competing for to
lock the same row or object.
Is there any existing tooling that does this? I'm loath to start hacking
something up when I'd hope others have done a better job already...
Chris
fer not to be making
opportunistic/guessing changes on this.
How can I collect metrics/logging/etc evidence to confirm what the
problem actually is?
cheers,
Chris
ts
logged down together with it?
Nope, only ones logged are these updates.
Chris
ent behaviour of != ANY (ARRAY...) is not useful, then is there any
support for (or opposition to) fixing it? And is it a bug that one can't use
unnest in a NOT IN expression in the WHERE clause?
Thanks, Chris.
that WAL and what's
likely to be causing any problems.\
More generally, what's number of WALs is "too much"? check_postgres.pl
when used in nagios format only appears to be able to alert on absolute
thresholds, does this always make sense? What's a good threshold to
alert on?
cheers,
Chris
On 11/12/2018 14:48, Achilleas Mantzios wrote:
On 11/12/18 4:00 μ.μ., Chris Withers wrote:
I'm looking after a multi-tenant PG 9.4 cluster, and we've started
getting alerts for the number of WALs on the server.
It'd be great to understand what's generating all that WAL a
time later (and after a reboot) yum update
succeeded and we never found out why.
I think we can archive this as a one-time glitch with yum.
Bye,
Chris.
, I suggesttransaction bundling (one commit every 1000 records or so),
depending on context.
Bye,
Chris.
every N records, where
N is the total count :)
I just wanted to make shure OP will not commit after each COPY.
Bye.
Chris.
t instead.
>
> Don't use Postgres like cache, don't use Postgres for non transactional
> short life often updated data.
>
> Use inmemory databases instead
>
> Pavel
>
>
>>
>> Regards,
>>Thomas Güttler
>>
>>
>> --
>> Thomas
On Thu, Feb 28, 2019 at 1:50 PM Nicolas Grilly
wrote:
> On Thu, Feb 28, 2019 at 1:24 PM Chris Travers
> wrote:
>
>> 1. a) TB-scale full text search systems.
>> b) PostgreSQL's full text search is quite capable but not so
>> powerful that it can completely r
If you are considering MySQL you
might want to use MariaDB instead. But PostgreSQL avoids most of these
issues and ensures that even if you are distributing the db with a
proprietary application, there are no licensing implications of doing that.
> Regards,
> Sonam
>
--
Best Wishes,
Chri
t direction.
>
> The only mechanism available to put any semantics into the database is via
> the naming of identifiers. Why screw with that? Imagine what would happen
> if your IDE decided to do that to your java code.
>
>
> Different languages address case and identif
es.
> You have no idea how large a can of worms that opens (but I'll just
> mention that "which characters are letters" doesn't even have a well
> defined universal answer).
>
+1
>
> regards, tom lane
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
time and can often avoid running it on selection time if it
is just a part of the where clause.
In my experience usually we have used trigger-updated functions when the
field values are very large or expensive, and may need to be part of the
column list, and functions with functional indexes whe
n indexes
So you can:
create index foo on bar ((id % 1000));
And then use the index on:
select * from bar where id % 1000 = 45;
You could similarly
create index foo on bar (extract(day from date_field));
The left side needs to be indexed (and an immutable expression) but beyond
that.
>
&g
mption inefficiency (in
> comparison to MySQL) problem?
>
Long run pluggable storage should give people a different set of options
and choices to make here.
>
> Many thanks,
>
> sps-ray
>
>
> ---
> This email has been checked for viruses by Avast antivirus software
/red_hat_enterprise_linux/7/html/load_balancer_administration/s1-initial-setup-forwarding-vsa
Met vriendelijke groet,
REDstack BV
Chris Coutinho
Researcher/Data Analyst
Van: Lu, Dan
Verzonden: dinsdag 7 mei 2019 14:12
Aan: David G. Johnston ; Alvaro Aguayo Garcia-Rada
; pgsql-gene...@postgresql.org
Onderwerp
Hi All,
Is there any way to grant rights to a user such that they can drop and
re-create only a single database?
cheers,
Chris
On 05/06/2019 09:52, Laurenz Albe wrote:
Chris Withers wrote:
Is there any way to grant rights to a user such that they can drop and
re-create only a single database?
No; what I'd do if I needed that is to create a SECURITY DEFINER function
that is owned by a user with the CREATEDB priv
the big names that use Postgres, e.g. MasterCard, Government
> agencies, Banks, etc.
> >
> You might be interested in this:
> https://www.theguardian.com/info/2018/nov/30/bye-bye-mongo-hello-postgres
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP.
On Fri, Jun 2, 2023, 09:36 Oliver Kohll wrote:
> Hi,
>
> Just wondering, does anyone else create apps which might not have 'big'
> data, but quite complex arrangements of views joining to each other?
>
> If so, do you have scripts to aid refactoring them e.g. drop/recreate/test
> them in the righ
stgresql
> > password to the same password at once.
>
> To the same value??
>
> --
> Born in Arizona, moved to Babylonia.
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
up
>> pg_dumpall --globals-only > globals.sql
>>
>
> What is the relevance of globals-only and what this will do ${DB}.log
> // or is it ${DB}.sql ?
>
> pg_dump --format=d --verbose --jobs=$THREADS $DB &> ${DB}.log // .log
>> couldn't get an idea what it mean
>>
>> If you're 100% positive that the system you might someday restore to is
>> *exactly* the same distro & version, and Postgresql major version, then
>> I'd use PgBackRest.
>>
>> --
>> Born in Arizona, moved to Babylonia.
>>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
creating all
the partitions you expect even if they are empty, and seeing how long
EXPLAIN takes to run. If that's good enough, then go for it. If it is too
long then you could pre-calculate what partition to hit or you could use
fewer partitions.
>
> Thanks.
>
>
--
Best Wishes
The need has mostly passed (I used another computer with Ubuntu 20) but are
there clear, *working* instructions for how to connect to Postgress on Ubuntu
18 via PDO? I don't see drivers that would work. This is for a Drupal site.
be
verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29".
On Friday, September 22, 2023 at 02:38:24 PM PDT, Ray O'Donnell
wrote:
On 22 September 2023 21:40:38 Chris Kelly wrote:
The need has mostly passed (I used another computer with Ubuntu
Suddenly everything becomes clear: I'm running an OS that reached EOL 3 months
ago. I'll upgrade to Ubuntu 20 if I need to get it working on this computer.
Thanks.
On Saturday, September 23, 2023 at 02:15:19 PM PDT,
wrote:
Am 23.09.23 um 20:56 schrieb Chris Kelly:
&g
t;
>
>
>
>
> best regards,
> Ilya Kosmodemiansky,
> CEO, Data Egret GmbH
> Herrenstr. 1 A 2,
> Spiesen-Elversberg, Germany
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
e other reasons to rewrite but it really depends on a
lot of factors.
>
> Yours,
> Laurenz Albe
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
between myself and the audience.
Slides should be a mnemonic device for you as a speaker and for the
audience later, not a source of direct information except when you need a
visual exploration and then the images are helpful.
>
>
> HTH,
>
> SteveT
>
> Steve Litt
>
> Autumn 2023 featured book: Rapid Learning for the 21st Century
> http://www.troubleshooters.com/rl21
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
Hi everyone,
Does anyone here know if the default PostgreSQL images set NUMA policies?
I am assuming not? Is there an easy way to make them do this?
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
ndicators.
However, once these errors start happening, you are in danger territory and
need to find out why (and correct the underlying problem) before you get
data loss.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Thu, Nov 30, 2023 at 9:03 AM Abdul Qoyyuum
wrote:
> Hi Chris,
>
> On Wed, Nov 29, 2023 at 7:38 PM Chris Travers
> wrote:
>
>>
>>
>> On Wed, Nov 29, 2023 at 4:36 PM Abdul Qoyyuum
>> wrote:
>>
>>> Hi all,
>>>
>>> Knowi
eneral approach is to COPY FROM STDIN and then use pg_putcopydata for
each row, and finally pg_putcopyend to close out this. It's not too
different from what psql does in the background.
>
>
> --
>
> Bien à vous, Vincent Veyron
>
&g
uldn't prune.
>
Was there a datatype issue here? Like having a partition key of type
timestamp, but the query casting from date?
>
> When I departitioned the tables, performance became acceptable.
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
PostgreSQL 15 on Debian, both ends of replication.
I'm doing logical replication in a bit of a complex setup. Not sure
how much of this is relevant so I'll give you a lot of detail; sorry
if a lot of this is just noise.
* Bidirectional alternating-master replication. Since I'm still on PG
15, the
On Mon, 22 Jan 2024 at 05:25, Justin wrote:
>
> When using replica set to full this kicks off a full table scan for each
> update or delete this is very expensive. If there are no errors being
> reported you will find it is working but hung doing full scans. Inserts are
> just appended to e
On Mon, 22 Jan 2024 at 05:50, Chris Angelico wrote:
>
> On Mon, 22 Jan 2024 at 05:25, Justin wrote:
> > Adding a primary key will fix this issue. Note PG 16 can use indexes to
> > find qualifying rows when a table's replica is set to full.
>
> I'll try dro
After various iterations of logical on PG 15, I bit the bullet and
installed PG 16. (Using the bookworm-pgdg repository.) Turns out, that
basically solved all the problems I'd been having previously - yay!
Got a bit of a curveball thrown at me though. I have a singleton
settings table (see other t
On Fri, 2 Feb 2024 at 13:20, Chris Angelico wrote:
> create or replace function send_settings_notification() returns
> trigger language plpgsql as $$begin perform
> pg_notify('stillebot.settings', ''); return null; end$$;
> create trigger settin
time commitment
irequirements are not set. Any amount of help is welcome no matter how
small.
Is anyone interested in helping out?
Best Wishes,
Chris Travers
ion is to require a password plus
clientcert=sameuser. This allows you to authorize devices/user accounts
for specific remote database connections and provides that second factor --
i.e. something you have as well as something you know.
>
>
> Regards
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
Abramova, Sergei Kim, Simon Pain, and Chris Travers currently sit
on the committee.
Chris Travers is currently acting as chair.
More information about those on the committee can be found at the above
link.
Best Wishes,
Chris Travers
Interim Chair, Code of Conduct Committee
to tell us about yourself that is helpful for us
to know about your potential involvement with the CoC Committee?
Please be sure to send your reply to the CoC email listed above. Thank you!
Regards,
Chris Travers
Acting Chair
PostgreSQL Community Code of Conduct Committee
On Tue, Aug 27, 2024, 5:09 AM Chris Travers wrote:
> This message is being sent from the Community Code of Conduct Committee,
> with the approval of the Core Team.
>
> As part of the Community CoC policy, the Committee membership is to be
> refreshed on an annual basis. We are
failed for user "postgres"
Notice I am failing “peer” authentication. Seems to me that if I explicitly ask
for a password, “-W”, I should be using “md5” authentication.
Can anybody straighten me out?
Thanks for the help,
--
Chris.
e everything matches all/all.
> There is no way to give a user a choice of how to authenticate. There will be
> one accepted option for a given set of connection values.
This answers my question. Thanks for the help,
--
Chris.
Hi Adrian,
> First match wins loses in this case. The entries are processed top to
> bottom the first the one matches in this case:
>
> local all all peer
>
> Per
This answers my question. Thanks for the help,
--
Chris.
I'm trying to run pgbouncer but am having trouble with what looks like a
very simple configuration.
centos 7
postgres 12
pgbouncer 1.15
we are already using pam for database auth. pgbouncer was compiled with
--with-pam. there is a /etc/pam.d/pgbouncer config file copied from the one
currently bei
arting up. any
suggestions on how to completely remove and reinstall with support for pam?
On Wed, Apr 28, 2021 at 1:51 AM Laurenz Albe
wrote:
> On Tue, 2021-04-27 at 19:46 -0500, Chris Stephens wrote:
> > I'm trying to run pgbouncer but am having trouble with what looks like
I had to install pam-devel before reinstalling pgbouncer. appears to be
working now. thanks for pointing me in the right direction Laurenz!
On Wed, Apr 28, 2021 at 7:09 AM Chris Stephens
wrote:
> huh. you are right. i originally installed pgbouncer with yum but removed
> with just "
rther. Kind regards, James
>
If you are posting here, is it because they want to move all these to
PostgreSQL?
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
ght true for Sybase, but I've never done a
> detailed comparison.
>
Indeed. MongoDB has some interesting features like capped collections
which make it useful as a cache, but my experience always leaves me feeling
like performance and scalability are lacking.
>
>
> Cheers,
> Gav
. I've also opened a ticket with
AWS's support to see if they have any ideas. For now, we've had to go back
to using the single threaded pg_dump (which is disappointing because it's
25 minutes slower). We were really hoping to take advantage of the
parallelism.
Any ideas would be much appreciated.
Thanks,
Chris
, but
I'm unsure how much their regular Postgres offering differs, if at all.
Thanks,
Chris
On Mon, Oct 18, 2021 at 8:05 PM Tom Lane wrote:
> Chris Williams writes:
> > We have a script that runs a pg_dump off of an RDS PG13.3 replica several
> > times per day. We then load t
n the picture. And there are
other areas of complexity, such as how you handle partial page writes.
On the whole I think for small dbs it might perform well enough. On large
or high velocity dbs I think you will have more problems than expected.
Having worked with PostgreSQL on ZFS I wouldn't
,
Chris
On 14/05/2020 21:11, Chris Withers
wrote:
Hi,
I'm upgrading a database from 9.4 to 11.5 by dumping from the
old cluster and loading into the new cluster.
The database is tiny: around 2.3G, but importing this table is
pr
o just roll their
own solutions.
>
> > Trying to write documentation on how to develop a complete solution
> > would be quite an effort and would certainly go beyond bash scripting
> > and likely wouldn't end up getting used anyway- those who are developing
> > such s
Make it stap :'(
On 20/11/2017 17:55, Zacher, Stacy wrote:
On Nov 30, 2017 08:35, "Durumdara" wrote:
Hello!
Somewhere the users made mistakes on prices (stock).
I need to search for big differences between values.
For example:
20
21
21,5
30
28
..
46392 <-
46392 <-
But it could be:
42300
43100
44000
43800
65000 <-
42100
Human eye could locate these
I need to search for big differences between values.
[...]
Hi,
from an SQL point of view this is not difficult, but you need to
carefully define a criteria for the outliers.
For example, to find values that are more than a standard deviation
away from the mean, do something like this:
chris
to
force the user to jump through hoops to add an IDENTITY column.
Thanks, Chris.
h top or uptime)?
Bye,
Chris.
Hello,
How would I investigate if my database is nearing a transaction wrap around.
Best Regards,
Chris
aces. Stay
tuned ;-)
>
> Kind regards
>
> Thiemo
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
digit to the right of the decimal point.
>>> --
>>> Mike Nolan
>>>
>>>
>>
> >Percentage calculation exists in almost any databse and information
> system
>
> That is not exactly true. AFAIK, only Oracle has a Percentage function.
> SQL Server and MySQL do not.
> It has already been shown that it is just as easy to code percentage
> inline (EG: SELECT (50.8 x 5.2) / 100 AS pct; ## .026416
> as it is to call a function SELECT pct(50.8, 5.2);
> Please do not false statements to justify a request for a non-needed
> enhancement.
>
>
>
> --
> *Melvin Davidson*
> I reserve the right to fantasize. Whether or not you
> wish to share my fantasy is entirely up to you.
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
ostgreSQL via RX Javascript?
If that is the case, then this question has nothing to do with PostgreSQL
and is a question for whatever RXJS implementation you are using.
Regards,
Chris
>
101 - 194 of 194 matches
Mail list logo
