Hello Peter,
In this case, It was a COPY for a table to out of the database, but the error
occurs with other commands like a SELECT.
Thanks in advance,
Flaris.
Flaris R. Feller
flaris.fel...@gmail.com
http://linkedin.com/in/flarisfeller
> Em 22 de jun de 2020, à(s) 12:33, Peter J. Holzer
Hello Rob,
You mean, an insert or update carrying this value? No, it doesn’t.
Thanks,
Flaris.
Flaris R. Feller
flaris.fel...@gmail.com
http://linkedin.com/in/flarisfeller
> Em 22 de jun de 2020, à(s) 11:28, Rob Sargent
> escreveu:
>
>
>
>> On Jun 22, 2020, at 8:13 AM, Flaris Feller
Hello all,
I’ve got successfully isolate and delete the corrupted rows at the table, but
what would caused that? How to prevent it?
Thanks in advance,
Flaris.
Flaris R. Feller
48-999811781
flaris.fel...@gmail.com
http://linkedin.com/in/flarisfeller
> Em 22 de jun de 2020, à(s) 13:54, Tom
On 2020/08/04 19:21, Stelios Sfakianakis wrote:
> Thank you again, I have another question in order to make sure I have a clear
understanding:
>
>
>> On 4 Aug 2020, at 11:24, Ian Lawrence Barwick wrote:
>>
>> The hash table is specific to each running backend so will only be
>> accessed by that
On 2020/08/04 19:21, Stelios Sfakianakis wrote:
> Thank you again, I have another question in order to make sure I have a clear
understanding:
>
>
>> On 4 Aug 2020, at 11:24, Ian Lawrence Barwick wrote:
>>
>> The hash table is specific to each running backend so will only be
>> accessed by that
> On Aug 10, 2020, at 15:19, Mark Phillips wrote:
> Advice, cautionary tales, suggestions and such will be warmly received.
Here's one solution a company found for this; it seems to work very well:
https://instagram-engineering.com/sharding-ids-at-instagram-1cf5a71e5a5c
--
--
Given four instances of posgres, each with a database, each instance receiving
new data, and desiring a data “merge” a la BDR or similar multiple database
solutions, my team has been discussing the pros and cons of generating unique
keys in each table.
1. create a unique “database” id for each
On Mon, Aug 10, 2020 at 1:45 PM Israel Brewster
wrote:
>
>
> > On Aug 10, 2020, at 12:06 PM, Peter J. Holzer wrote:
> >
> > On 2020-08-10 09:10:00 -0800, Israel Brewster wrote:
> >> I would point out, however, that using a V1 UUID rather than a V4 can
> >> help with this as it is sequential,
On 8/10/20 10:53 AM, Stephen Frost wrote:
Greeitngs,
* Ron (ronljohnso...@gmail.com) wrote:
On 8/10/20 11:38 AM, Ravi Krishna wrote:
Finally UUID results in write amplication in wal logs. Keep that in mind
if your app does lot of writes.
Because UUID is 32 bytes, while SERIAL is 4
> On Aug 10, 2020, at 12:06 PM, Peter J. Holzer wrote:
>
> On 2020-08-10 09:10:00 -0800, Israel Brewster wrote:
>> I would point out, however, that using a V1 UUID rather than a V4 can
>> help with this as it is sequential, not random (based on MAC address
>> and timestamp + random).
>
> If
"David G. Johnston" writes:
> On Mon, Aug 10, 2020 at 10:54 AM Shankar Bhaskaran
> wrote:
>> How does psql import the server certificate?
> It works by default because both the server and client are usually
> installed from the same source and the same default certificate files are
> provided
The convention on these lists is to inline or bottom-post.
On Mon, Aug 10, 2020 at 11:11 AM Martin Gainty wrote:
> cant you use keytool ?
>
That wasn't the question, the OP already indicated they can do this
successfully in JDBC.
David J.
On Mon, Aug 10, 2020 at 10:54 AM Shankar Bhaskaran
wrote:
> How does psql import the server certificate?
>
See:
https://www.postgresql.org/docs/12/libpq-envars.html
Namely the "PGSSL*" prefixed environment variables.
It works by default because both the server and client are usually
On 2020-08-10 09:10:00 -0800, Israel Brewster wrote:
> I would point out, however, that using a V1 UUID rather than a V4 can
> help with this as it is sequential, not random (based on MAC address
> and timestamp + random).
If I read the specs correctly, a V1 UUID will roll over every 429
seconds.
cant you use keytool ?
assume server certificate is called server.crt
assume truststore file is called server.truststore.jks
cd %JRE_HOME%/lib/security
keytool -import -alias %ALIAS% -file server.crt -keystore server.truststore.jks
m.
From: Shankar Bhaskaran
Hi All,
This is a very basic question . i have to import the server.crt on the
client side java trustore to connect using jdbc to postgres server secured
by ssl.
But when i try psql from same machine , it shows the connection as
encrypted . How does psql import the server certificate?
psql
>
> Sorry about the top-posting, Firefox and I disagreed about whether I was
> done editing the previous message.
>
--
Mike Nolan
I usually use something like trim(field) like 'pattern'. Eliminates the
need for the wildcard at the end. I find I use the ~ operator more than
'like' though.
--
Mike Nolan
On Mon, Aug 10, 2020 at 12:24 PM Adrian Klaver
wrote:
> On 8/10/20 10:01 AM, Michael Nolan wrote:
> > The problem is
> I would point out, however, that using a V1 UUID rather than a V4 can
help with this as it is sequential, not random (based on MAC address and
timestamp + random)
I wanted to make this point, using sequential UUIDs helped me reduce write
amplification quite a bit with my application, I didn't
On 8/10/20 10:01 AM, Michael Nolan wrote:
The problem is your field is fixed length text, change it to
varchar(100) or text and it works without the wildcard at the end.
That assumes values don't get entered with spaces:
create table lll (text varchar(100));
insert into lll (text) values
Greetings,
* Israel Brewster (ijbrews...@alaska.edu) wrote:
> > On Aug 10, 2020, at 8:53 AM, Stephen Frost wrote:
> > * Ron (ronljohnso...@gmail.com) wrote:
> >> On 8/10/20 11:38 AM, Ravi Krishna wrote:
> >>> Finally UUID results in write amplication in wal logs. Keep that in mind
> >>> if your
---
Israel Brewster
Software Engineer
Alaska Volcano Observatory
Geophysical Institute - UAF
2156 Koyukuk Drive
Fairbanks AK 99775-7320
Work: 907-474-5172
cell: 907-328-9145
> On Aug 10, 2020, at 8:53 AM, Stephen Frost wrote:
>
> Greeitngs,
>
> * Ron (ronljohnso...@gmail.com) wrote:
>> On
The problem is your field is fixed length text, change it to varchar(100)
or text and it works without the wildcard at the end.
--
Mike Nolan
On 8/10/20 9:51 AM, Ron wrote:
On 8/10/20 11:38 AM, Ravi Krishna wrote:
[snip]
Finally UUID results in write amplication in wal logs. Keep that in
mind if your app does lot of writes.
Because UUID is 32 bytes, while SERIAL is 4 bytes?
You mean 32 digits for 128 bits?:
Greeitngs,
* Ron (ronljohnso...@gmail.com) wrote:
> On 8/10/20 11:38 AM, Ravi Krishna wrote:
> >Finally UUID results in write amplication in wal logs. Keep that in mind
> >if your app does lot of writes.
>
> Because UUID is 32 bytes, while SERIAL is 4 bytes?
and because it's random and so will
On 8/10/20 9:37 AM, p...@gmx.de wrote:
Hello,
my SQL question is, why psql doesn't return the record?
create table lll (text char(100));
insert into lll (text) values ('10% - Ersthelfer');
select * from lll where text like '10% - Ersthelfer';
Other databases (Maria, SQL Server, YARD) do
On 8/10/20 11:38 AM, Ravi Krishna wrote:
[snip]
Finally UUID results in write amplication in wal logs. Keep that in mind
if your app does lot of writes.
Because UUID is 32 bytes, while SERIAL is 4 bytes?
--
Angular momentum makes the world go 'round.
UUID are also random and not correlated with time typically, so with a very
large table when accessing primarily recent data, hitting an index on a big
table will pull random pages into memory instead of primarily the end of
the index.
On 8/10/20 11:37 AM, p...@gmx.de wrote:
Hello,
my SQL question is, why psql doesn't return the record?
create table lll (text char(100));
insert into lll (text) values ('10% - Ersthelfer');
select * from lll where text like '10% - Ersthelfer';
Other databases (Maria, SQL Server, YARD) do
Both can handle concurrent writes. auto-increment is nothing but serial or
sequence cols and they can handle unique concurrent request. That is why
sometimes you may have gaps.UUID is not only unique, but is also unique across
space. You can have two different databases generate UUID at the
Hello,
my SQL question is, why psql doesn't return the record?
create table lll (text char(100));
insert into lll (text) values ('10% - Ersthelfer');
select * from lll where text like '10% - Ersthelfer';
Other databases (Maria, SQL Server, YARD) do this.
What can I do in pg, to get the
Hi,
for web application is it needed to use UUID or auto-increment?
1- if two user inserts row at the same time, does it work?
2- dose the database give the same id for both users or execute one of them
first? ( I mean ID conflict not happens?)
Thanks.
Hi Team,
We have observed that xact_start time is null for some period and suddenly it
populates to very old value. We have a query which runs every minute to report
any transactions running for long time. That query reports nothing continuously
for a minute before and suddenly it reports one
33 matches
Mail list logo