Hi!
Price list of main products vordlusajuhinnak contains 3 prices for
product (column toode) and has 39433 products:
create table vordlusajuhinnak( toode varchar(60), n2 numeric(8,2),
n3 numeric(8,2), n4 numeric(8,2) );
toode column in unique, may be primary key in table and contains u
On 5/22/23 18:42, Tom Lane wrote:
Jeff Ross writes:
On 5/22/23 5:24 PM, Adrian Klaver wrote:
So is the 1400G mostly in one database in the cluster?
Yes, one big database with about 80 schemas and several other smaller
databases so -j should help, right?
AFAICT from a quick look at the code,
> Hi pgsql-general,
>
> Will there be any option to attend the upcoming PG conference remotely?
>
> Will the talks and papers be posted online following the conference, if not?
You can contact the conference organizer via email.
https://www.pgcon.org/2023/contact.php
Best reagards,
--
Tatsuo I
On 5/22/23 16:29, Jeff Ross wrote:
On 5/22/23 5:24 PM, Adrian Klaver wrote:
On 5/22/23 16:20, Jeff Ross wrote:
Hello!
From docs:
https://www.postgresql.org/docs/current/pgupgrade.html
The --jobs option allows multiple CPU cores to be used for
copying/linking of files and to dump and res
Jeff Ross writes:
> On 5/22/23 5:24 PM, Adrian Klaver wrote:
>> So is the 1400G mostly in one database in the cluster?
> Yes, one big database with about 80 schemas and several other smaller
> databases so -j should help, right?
AFAICT from a quick look at the code, you won't get any meaningful
On 5/22/23 5:24 PM, Adrian Klaver wrote:
On 5/22/23 16:20, Jeff Ross wrote:
Hello!
We are moving from 10 to 15 and are in testing now.
Our development database is about 1400G and takes 12 minutes to
complete a pg_upgrade with the -k (hard-links) version. This is on a
CentOS 7 server with 80
On 5/22/23 16:20, Jeff Ross wrote:
Hello!
We are moving from 10 to 15 and are in testing now.
Our development database is about 1400G and takes 12 minutes to complete
a pg_upgrade with the -k (hard-links) version. This is on a CentOS 7
server with 80 cores.
Adding -j 40 to use half of thos
Hello!
We are moving from 10 to 15 and are in testing now.
Our development database is about 1400G and takes 12 minutes to complete
a pg_upgrade with the -k (hard-links) version. This is on a CentOS 7
server with 80 cores.
Adding -j 40 to use half of those cores also finishes in 12 minutes
On Sat, May 20, 2023 at 9:43 AM Marcos Pegoraro wrote:
> I have a table like pg_settings, so records have name and value.
> This select is really fast, just 0.1 or 0.2 ms, but it runs millions of
> times a day, so ...
>
> Then all the time I have to select up to 10 of these records but the
> resu
On 5/22/23 15:06, Adrian Klaver wrote:
On 5/22/23 12:38, Ron wrote:
On 5/22/23 14:22, Tony Xu wrote:
RDS Postgresql would do the job just fine. And since you can't get to
the files (only access it via port 5432 and aws cli/web, there's no need
for TDE.
As I understand TDE whether you can
> On May 22, 2023, at 13:06, Adrian Klaver wrote:
> As I understand TDE whether you can get to the files is not really the point.
> It is that someone/thing can and if they do the files are encrypted. Pretty
> sure RDS is not magical enough to have no access from any source to the file
> sys
On 5/22/23 12:38, Ron wrote:
On 5/22/23 14:22, Tony Xu wrote:
RDS Postgresql would do the job just fine. And since you can't get to
the files (only access it via port 5432 and aws cli/web, there's no need
for TDE.
As I understand TDE whether you can get to the files is not really the
poin
(please read http://deb.li/quote and don’t top-post)
On Mon, 22 May 2023, Tony Xu wrote:
>First question - do we, as a community, see the value of the proposal and
>do we believe that value is big enough for us to make any necessary changes
I’d rather like to see the energy, if there’s some inve
On 5/22/23 14:22, Tony Xu wrote:
Thanks Christophe for the clarification.
That's not quite right. A PostgreSQL cluster (in the traditional
sense, which means one PostgreSQL server handling a particular
endpoint) is isolated from any other clusters on the same machine.
Thanks. I thi
Thanks Christophe for the clarification.
That's not quite right. A PostgreSQL cluster (in the traditional sense,
> which means one PostgreSQL server handling a particular endpoint) is
> isolated from any other clusters on the same machine.
>
Thanks. I think I had a misunderstanding over the "clu
> On May 22, 2023, at 11:02, Tony Xu wrote:
> there are still some shared area between clusters.
That's not quite right. A PostgreSQL cluster (in the traditional sense, which
means one PostgreSQL server handling a particular endpoint) is isolated from
any other clusters on the same machine.
Thanks all for the discussions. It sounds like there are different
questions to clear before we can get to a conclusion on if per-database KEK
is possible or not.
First question - do we, as a community, see the value of the proposal and
do we believe that value is big enough for us to make any nec
On 5/20/23 07:09, Pedro Gonçalves wrote:
Hi.
Good afternoon.
I’m having dificulties with localhost DBeaver postgres training account.
Had access to it and changed password, that presently don’t remember.
What can I do to get access again?
From DBeaver I was told to address this request to P
On 5/22/23 04:38, Rajmohan Masa wrote:
Hi Adrian,
I Found one thing in my base Directory.
Generally we are having OID in the Base Directory with a unique OID But
in my machine I found some object Id's with sequence like
121193051,121193051.1 121193051.1200 and each file having the same
s
Hi pgsql-general,
Will there be any option to attend the upcoming PG conference remotely?
Will the talks and papers be posted online following the conference, if not?
Thank you,
Joe Hammerman
On Fri, May 19, 2023 at 9:50 PM Laurenz Albe
wrote:
> Yes, that's what I would expect. There is only one "backend_xmin" in
> "pg_stat_replication", which corresponds to the snapshot held by the oldest
> query in any database on the standby server.
>
Thanks for the pointer to pg_stat_replication
On 5/20/23 09:09, Pedro Gonçalves wrote:
Hi.
Good afternoon.
I’m having dificulties with localhost DBeaver postgres training account.
Had access to it and changed password, that presently don’t remember.
What can I do to get access again?
From DBeaver I was told to address this request to P
On Sat, May 20, 2023 at 4:43 PM Marcos Pegoraro wrote:
> I have a table like pg_settings, so records have name and value.
>
Hi. Maybe I'm missing something, but why aren't you simply doing:
select name, varvalue from sys_var where name = any($1)
and binding your 4 (in your examples) or 10
23 matches
Mail list logo
