ess=5 -v -Fd -f "$name.$$" $db 2>&1 | ts >
log/"$name".$(isodate).log
ts is available here: https://github.com/hjp/simple/tree/master/ts
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h..
ion
parameter. It is language-specific and therefore user-specific if you
have international users. (I acknowledge the potential performance
problems, but they are the same with an explicit collation clause).
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
ge contains a script pg_upgradecluster which
knows about the distribution-specific directory layout. You would
normally use that script instead pg_upgrade directly.
Maybe the Fedora package has something similar?
hp
--
_ | Peter J. Holzer| Story must make more sense th
obably because most MUAs displayed only one
message at a time. The first MUA I've seen that displayed an entire
thread at once was Gmail.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Char
re is. My rule od thumb is that it should be short
enough to read as part of the message. Of course this is very subjective
and may even depend on my mood (Sometimes I find a 20 line SQL query too
long, sometimes I'm happy to dig through 200 lines of Perl code ...). It
also depends very much on
d prefer to not get an extra copy directly. (but I can live with
that).
Of course the mailing list server can't filter mails it never sees.
Mutt adds a header to indicate the preferences of the sender, but I
think that is only recognized by mutt, so it's not a general solution.
really an image to show a problem, it can be put on
> some server and the link could be posted, like this one showing a PANIC
> of a system http://www.unixarea.de/fbsd-panic-20210110.jpg
That has the disadvantage of not being archived.
hp
--
_ | Peter J. Holzer| Story must
appen pretty quickly on a busy
database. The question is: Does that help you? At that point the data is
already gone (at least partially), and you can only restore it from
backup.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) |
s finished. FInally among those where the performance
was acceptable choose the value which was fastest.
(Note: If you do this on the same database, subsequent runs will benefit
from work already done, so the take the results with a grain of salt).
hp
--
_ | Peter J. Holzer
investigate what went wrong than to
blindly make some changes to the code.
As a first measure I would at least turn on statement logging and/or
pg_stat_statements to see which statements are slow, and then
investigate the slow statements further. auto_explain might also be
useful
andom sample (if
devices report at random times) or empty (if they all report at midnight
and it isn't just after midnight).
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles
that you can probably afford a few messages, even if each
function invocation only takes a few milliseconds. So definitely try
that if you need to know where your functions spend their time.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
take this much
> time.
How much time is "this much time"? Are we talking a few milliseconds
here? Less? More? Much more?
It's hard to give advice if you don't tell us more than "slower than SQL
server". Please be specific. Use actual numbers.
hp
--
t did not exist before.
Or just more of them. I could imagine that switching from
Python/Gunicorn to Go increased the number of queries that could be
in-flight at the same time.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| |
API pretty much guarantuees the existence of a connection
pool).
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challen
that's
a function of load in general, not the number of applications.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | c
ill be able to use it. In reality that doesn't help
non-programmers much (it's still a formal language with precise
semantics and the computer will do what you say, not what you mean), but
makes it harder for programmers.
hp
--
_ | Peter J. Holzer
quite small by default so you
might want to increase it. The usual recommendation is to start with 25%
of the memory (that would be 16 GB in your case) and then see if it gets
better if decrease or increase it.
hp
--
_ | Peter J. Holzer| Story must make more sense than rea
photo, ...) try to cache that in the application. That
probably doesn't change very often and doesn't have to be retrieved
from the database every time.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.a
ave experience with trying this in a real-world workload? (I
was never brave enough)
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http:
On 2021-02-21 10:14:04 -0700, Michael Lewis wrote:
> No issues for us. We have used a low sample rate of 1% or so and gotten some
> very useful data.
Oh, somehow I never noticed the auto_explain.sample_rate parameter in
the docs. Good to know.
hp
--
_ | Peter J. Holzer|
trings, though, Especially if they
are known to cause trouble.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
poken in Germany ("DE").
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
foo('x*');
╔═╗
║ foo ║
╟─╢
║ x* ║
╚═╝
(1 row)
Time: 1.296 ms
hjp=> \q
So like others I suspect that SQLAlchemy is doing something weird here.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
might have additional reasons not to be in compliance. I don't
> read German unfortunately.
It defines minimal character set that IT systems which process personal
and company names in the EU must accept. Basically Latin, Greek and
Cyrillic letters, digits and some symbols and interpunc
(echo 'select * from pg_class;') < /dev/null
psql -f <(echo 'select * from pg_class;') > /dev/null
But
psql -f <(echo 'select * from pg_class;')
does, since both stdin and stdout are a terminal.
hp
--
_ | Peter J. Holzer|
dexes in Oracle don't store NULL values (bitmap indexes do store
NULL values, though - are they still an enterprise feature?).
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stros
und that by using float8 or even numeric instead
of int. Chances are that there is a free number between you numbers.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "C
is the execution plan?
* How long does it take?
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
nformation, so I could
be wrong) that you haven't configured a replication slot and you haven't
enough WAL segments to last through the downtime naturally.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
|
93 EDT [14755] STATEMENT: START_REPLICATION SLOT
> "xyzd3riardb05" 0/700 TIMELINE 18
...
> and after some time such errors stop to appear.
So the replication slot is probably created after some time and then
replication starts to work.
I think that replication slot is managed
ties by
> installing rlwrap and performing the following command:
While rlwrap is useful sometimes, I suggest reading the manual for
libedit might be a better option.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) |
On 2022-05-04 10:21:56 +0200, Zb B wrote:
> Apparently there is something wrong with my cluster. How to debug i?.
> Do I need to configure anything so the replication is synchronous?
Does https://patroni.readthedocs.io/en/latest/replication_modes.html
help?
hp
--
_ | P
;t you update both at the same time?
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
simpler:
create table products (
product_id serial primary key,
description text,
supplier_id integer references supplier
);
(You need to create supplier before doing that, of course.)
hp
PS: I noticed that "products" is plural and "s
book. For example, "Mastering PostgreSQL 9.6" has the ISBN
978-1-78355-535-2.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://ww
│ (∅) ║
╚═╧══╝
(4 rows)
Now, if title actually had a type which didn't include a null value,
this wouldn't be possible. Either the database would have to lie
(declare the column with a type but store a value which is impossible in
s itself.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
the
table. That should be faster since the index contains only 4 of 28 (if I
counted correctly) columns and should be quite a bit smaller. It's
possible that Oracle does this. But I'm not sure whether you could tell
that from the execution plan.
hp
--
_ | Peter J. Holzer|
compared to single values. So the you can
just jump to the first matching index and then get the next 50 entries.
> Is Postgres unable to optimize the query similar to Oracle? Is it possible
> this is possible but we are running on too old of a version?
PostgreSQL 10 is quite old, so t
On 2022-06-22 23:48:37 +0200, Peter J. Holzer wrote:
> On 2022-06-22 19:39:33 +, Dirschel, Steve wrote:
> > Posrgres version 10.11
> >
> > Here is the DDL for the index the query is using:
> >
> > create index workflow_execution_initial_ui_tabs
> >
On 2022-06-23 00:19:19 +0200, Peter J. Holzer wrote:
> On 2022-06-22 23:48:37 +0200, Peter J. Holzer wrote:
> > The index cannot be used for sorting, since the column used for sorting
> > isn't in the first position in the index.
>
> compared to a single value
^
On 2022-06-22 23:10:25 -0400, Jeff Janes wrote:
> On Wed, Jun 22, 2022 at 6:19 PM Peter J. Holzer wrote:
> >That's just how btree indexes work and Oracle will have the same
> >limitation. What would be possible is to use an index only scan
> >(returning
t isn't unique it is *not* a key. If your tables don't have a
primary key you should seriously rethink the data model.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, &qu
is wrong you would have to point at something
within the PostgreSQL documentation (ideally an entry in the glossary)
or some really wide-spread convention and the absence of a local
definition.
> Questions show many programmers are confused about the difference.
Which might be a hint that no wid
inconvenient if
that wasn't possible.
Do you have an example on where a grant prevents dropping an object?
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Cre
ex: 19). But in Postgres
> the
> same query returns result as "19 days".
Which PostgreSQL version is this?
I get 19 with PostgreSQL 11.16 and 14.0.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@h
er". (Please include relevant details when you ask a
question here - don't expect people to look at a stack overflow
question).
> How can I fix that `();` issue? Is this documented behavior?
My guess is that's a bug in DBeaver.
hp
--
e
changes also result in an atomic disk write seems to be both pointless
and impossible (that might be many gigabytes of data).
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charle
On 2022-07-12 13:07:41 -0600, Rob Sargent wrote:
> I thought OP was hinting at WAL stuff defn here
So did I.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative
r to connect to an oracle database that's too old or
too new (or you may be able to connect and then get weird errors -
BTDT). PostgreSQL is in my experience rather tolerant of client/server
mismatches, but I wouldn't be surprised if some stuff wouldn't work if
the versions are too diff
r is quite a bit faster that copying into the
database (and therefore also copying out AND copying in).
hp
[1]
https://github.com/hjp/dbbench/blob/master/import_pg_comparison/results/akran.2019-12-15/results.png
--
_ | Peter J. Holzer| Story must make more sense than re
aster, as last time I looked (it's been
some time) the optimizer wasn't especially good at handlung DISTINCT
FROM (probably because it's so rarely used).
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@h
ght.
Otherwise: For the same reason I would prefer B, I would prefer the one
with the most up-to-date data. But there might be other considerations,
e.g. the network connections (bandwidth and delays) between the
surviving members and the clients.
hp
--
_ | Pete
On 2022-08-06 15:06:06 -0500, Ron wrote:
> On 8/6/22 03:40, Peter J. Holzer wrote:
> > Using sync replication on an unstable link is probably not a good idea.
> > Every time the link goes down, A freezes. Is this what you want?
>
> I had to fight my end users about how to r
nd an fqdn at most 255
bytes. So without the scan id we are at 285 bytes. maybe a bit more due
to overhead. That leaves about 2400 bytes for the scan id. I don't know
what a scanid is, but 2000+ bytes for an id seems excessive.
hp
--
_ | Peter J. Holzer| Story
valuated) followed by a very quick count up (while
the result is transmitted to the client). Probably not what you want.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Cr
seconds, the progress
indicator is useless.
You are stuffing the whole result into an array and THEN counting the
number of elements. So when you get to the count all of the work (except
sending the result to the client) is already done, so there is little
point in displaying a progress indicator.
On 2022-08-16 14:42:48 -0700, Bryn Llewellyn wrote:
> hjp-pg...@hjp.at wrote:
> The OP wants some kind of progress indicator. To be useful, such
> an indicator should be approximately linear in time. I.e. if your
[...]
>
>
> I see, Peter. You’d read the OP’s mi
ursive query. That's theoretically possible but I would be
surprised if it actually did this. (It didn't in my tests, but my test
data set was too small to get it to even use indexes with normal
queries).
hp
--
_ | Peter J. Holzer| Story must make more sense
ed int
to an int halves the positive range. But it seems that this is already
capped at 2**31 days (5874897 AD), so that wouldn't be a problem here.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp
uncertainty of +/- 50 years?
I guess to really store "what do I know about when something happened"
you would have to be able to store a number of constraints (like
"between year x and y", "at least d years after event e", "between month
m and n", etc.)
ve your problem.
Isn't that what logical replication basically does?
I also think I've seen other tools parsing the WAL stream and doing
something useful with the results.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) |
. If I run
% sudo -u postgres -H /usr/lib/postgresql/13/bin/psql
(which is not a symlink)
I get the same behaviour. So it seems that psql changes to its basedir
and then can't change back again.
And sure enough, strace shows:
chdir("/usr/lib/postgresql/13/bin") = 0
chdir("/h
this affects auto_explain.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
PG-USERNAME
localusers rootpostgres
Then root can invoke `psql -U postgres ...`, but other users can't.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
On 2022-09-01 20:49:56 -0400, Jeffrey Walton wrote:
> On Thu, Sep 1, 2022 at 8:23 PM Peter J. Holzer wrote:
> >
> > On 2022-09-01 18:16:14 -0400, Tom Lane wrote:
> > > Jeffrey Walton writes:
> > > > We are having a heck of a time getting PostreSQL utilities to
eld4`: I have no
idea what this is supposed to do, so it's hard to tell if there is a
better way. Using `a` to refer to 3 different things doesn't help
either.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.a
efense. The database frequently won't
be accessible from the open internet (or even the company network)
directly. Only a middle tier of application servers running vetted
client code will connect directly. Even those servers may not be
accessible directly to end users. There may be a layer of proxy s
t; users. There may be a layer of proxy servers above them. Each of these
> > > layers may implement additional checks, rate limits and monitoring.
>
> If no one has direct SQL access to the database, then there's no problem with
> a
> role being able to pg_terminate_backe
ons ...)
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
On 2022-09-29 20:24:59 -0700, Bryn Llewellyn wrote:
> Paraphrasing Peter, the design of the application's RDBMS backend has to
> implement its own notions of roles and privileges as a new layer on top of
> whatever the native RDBMS mechanisms provide. Some RDBMSs have native
> pri
On 2022-09-30 17:59:01 -0700, Bryn Llewellyn wrote:
> hjp-pg...@hjp.at wrote:
> b...@yugabyte.com wrote:
> Paraphrasing Peter, the design of the application's RDBMS backend has
> to implement its own notions of roles and privileges as a new layer on
s of course assumes that the behaviour is intentional and not a
bug.)
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
itches to a generic plan if it
thinks that the generic plan isn't worse than the specialized plans.
If the plan suddenly gets worse after 5 executions, you've probably run
into a case where the generic plan is worse although the cost computed
by the planner isn't.
hp
--
_
On 2022-10-01 20:24:21 +0800, Julien Rouhaud wrote:
> On Sat, Oct 01, 2022 at 02:05:53PM +0200, Peter J. Holzer wrote:
> > On 2022-09-30 17:59:01 -0700, Bryn Llewellyn wrote:
> > > set rls.tenant_id=42;
> >
> > This works because there is a "." in the name.
║
╟──╢
║ 0.000100 ║
╚══╝
(1 row)
So the number of decimals by default isn't sufficient to represent
10^-18. You have to explicitely increase it.
hp
--
_ | Peter J. Holzer| Story must
imate in the first tuple changes
without any actual data change (although the only reason I can think of
right now would be an ANALYZE (in another session or by autovacuum)).
But the actual rows definitely shouldn't change.
hp
--
_ | Peter J. Holzer
nd when I check it says
[doesn't use /home/dmartuser/pgsql/14/data]
>
> How can I point the service to read the new path ( /home/dmartuser/pgsql/14/
> data )?
Check the systemd configuration file for this service.
hp
--
_ | Peter J. Holzer| Story must
initions the
same?
(Just trying to rule other other possible error sources.)
> I do apologize, but I do not understand the value of doing that select
> juggling.
I think Allan may have misread your mail.
hp
--
_ | Peter J. Holzer| Story must make more sens
On 2022-10-27 15:07:06 +0300, Kristjan Mustkivi wrote:
> On Thu, Oct 27, 2022 at 12:18 PM Peter J. Holzer wrote:
> > On 2022-10-27 10:55:31 +0300, Kristjan Mustkivi wrote:
> > > We use dockerized postgres.
> >
> > So that means you aren't just replaci
t at that time or does it just
issue a notice and continue to rebuild the other indexes? In the latter
case it migh be easy to miss a problem.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |--
dex, but why would you?)
> I do like this. I add oid in pg_am.dat and pg_proc.dat for my index.
> And I add codes in contrib and backend/access/myindex_name, is there
> any other places I need to add some infos?
What? Why are you doing these things?
hp
--
_ | Peter J. Ho
/s user is
> logging
> in using their own name as the requested login role.
I think that's not quite correct. The -U option affects which user name
psql uses to connect to the server. It is psql which defaults to the
OS user name in the absence of the -U option (or the PGUSER environment
arted: "su mary".
>
> 2. Then I want to start a session (I use "psql" here an an example) like
> this:
> "psql -d postgres".
>
> 3. Then, at the "psql" prompt, I want "select session_user" to show "bob".
Set the PGUSER=
AICS your test users aren't supposed to be that.
> uid=1001(postgres) gid=1001(postgres) groups=1001(postgres),27(sudo),114
> (ssl-cert)
And is there a reason for posgres to be in group sudo?
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) |
nant:~ 22:46 :-) 1016# su - 'mac$crooge'
mac@trintignant:~$ id
uid=1002(mac$crooge) gid=1003(mac$crooge) groups=1003(mac$crooge)
mac@trintignant:~$
I'm not saying that doing this is a good idea ...
hp
--
_ | Peter J. Holzer| Sto
t; select * from b;
╔╤═══╤══╗
║ id │ a │ t ║
╟┼───┼──╢
║ 1 │ 1 │ foo1 ║
║ 2 │ 1 │ foo2 ║
║ 3 │ 2 │ bar1 ║
╚╧═══╧══╝
(3 rows)
And the data in the table is also unchanged.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
nd even those that do
need only one key, so it is sufficient that only the server has a
certificate.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | h
sudo vi /etc/postgresql/14/main/pg_hba.conf
> [sudo] password for aklaver:
>
> which opens pg_hba.conf for editing.
Well, yes. Root can edit the file, too. But root can edit anything[1].
hp
[1] Except ... lots of stuff, actually.
--
_ | Peter J.
s the latter, your programming language's postgresql library
probably has a method for invoking copy.
> Has anything changed in the last ten years? Or, is there a
> better way to copy file contents in a remote database?
COPY is the fastest way to load data.
hp
--
_
you use copy_from()
you don't have to parse it (but then why use Python at all?)
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) ||
| | | h...@hjp.at |-- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
On 2022-11-09 12:57:23 -0600, Ron wrote:
> On 11/9/22 10:17, Peter J. Holzer wrote:
> > On 2022-11-07 14:40:40 -0600, Ron wrote:
> > > On 11/7/22 10:57, Вадим Самохин wrote:
> > > I have an application that must copy a local file in csv format to a
> > >
pdates, so again some may be HOT updated and some not. If you are
updating the same tupel several times, you may get a few HOT updates
first, then a non-HOT update, then HOT updates again.
hp
--
_ | Peter J. Holzer| Story must make more sense than reality.
|_|_) |
an appropriately configured role with
> "nosuperuser".
One important task that can AFAIK only be performed by superusers is the
creation of functions in untrusted languages like plpython3u and
plperlu.
If your application uses functions in those languages you ne
h
sounds reasonable) while the other reads 9995216 buffers (or almost one
full buffer per row). Why? The entries should be dense in the index in
both cases and since it's an index only scan (and explain says there
were 0 heap fetches) I would not expect extra accesses. Where do these
buffer reads
On 2022-11-18 15:59:46 -0500, Tom Lane wrote:
> "Peter J. Holzer" writes:
> > Both do a parallel index only scan. Both perform 0 heap fetches.
> > But one reads 27336 buffers (or about 22 bytes per index entry, which
> > sounds reasonable) while the other reads
On 2022-11-18 13:09:16 -0800, Peter Geoghegan wrote:
> On Fri, Nov 18, 2022 at 12:46 PM Peter J. Holzer wrote:
> > Both do a parallel index only scan. Both perform 0 heap fetches.
> > But one reads 27336 buffers (or about 22 bytes per index entry, which
> > sounds reason
y superusers is
> the creation of functions in untrusted languages like plpython3u
> and plperlu. If your application uses functions in those languages you
> need
> a superuser to install or upgrade it.
>
>
> Thanks, Peter. I experimented with the notion of restric
On 2022-11-18 16:21:18 -0600, Ron wrote:
> On 11/18/22 16:13, Peter J. Holzer wrote:
> > So you can give these credentials to you developers or devops folks
> > (whom you trust not attack the system -
>
> They like to "fix" things without documenting what they
501 - 600 of 979 matches
Mail list logo
