I use csv2table almost every day: https://github.com/f0rk/csv2table
to just emit a create table statement: csv2table --file your_csv.csv
pipe output to psql to create.
easily used to import data as: csv2table --file your_csv.csv --copy
--backslash -1 | psql your_database
use arguments like
Currently I'm working on upgrading a postgresql version from 9.3 to 12. The
database size is around 700G.
I finished the pg_upgrade process but when I ran 'analyze_new_cluster.sh'
it stucked at the first log 'vacuumdb: processing database "otdb":
Generating minimal optimizer statistics (1
ement?*
--
It's good to know that the query optimizer will improve with partitions on
versions 12+. Thank you.
Best,
Ryan
Ryan N Ruenroeng (He/His)
(717) 578-3929
| rruenro...@gmail.com
| Madison, WI <https://maps.google.com/?q=Madison,%20WI>
<https://github.com/rruenroeng> <htt
ally
track the statistics of these partitions and manually vacuum the tables or
will autovacuum help to manage them?
Best,
Ryan
Ryan N Ruenroeng (He/His)
(717) 578-3929
| rruenro...@gmail.com
| Madison, WI <https://maps.google.com/?q=Madison,%20WI>
<https://github.com/rruenroeng> <
ing a post are outlined in
the invite, but please feel free to reach out to me if you have any
questions.
https://www.softwareandbooz.com/pgsql-phriday-001-invite/
Regards,
Ryan Booz
Does anyone know what happened to the EDB windows postgresql 9.6 installers?
The host skips from 9.5->10
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
In a recent update (not sure when), the default for DBeaver seems to have
changed so that the navigator view is set to "simple", rather than
"advanced" which shows all objects.
Right-click the server -> edit connection -> Select "General" -> verify
"Navigator View"
On Fri, Oct 29, 2021 at 9:48
oth for your help.
Sincerely,
-Les
-Original Message-
From: Dilip Kumar
Sent: October 27, 2021 10:29 PM
To: Kyotaro Horiguchi
Cc: Ryan, Les ; pgsql-generallists.postgresql.org
Subject: Re: WAL File Recovery on Standby Server Stops Before End of WAL Files
On Thu, Oct 28, 2021 at 7:28 AM
ith
00010419005B but the restore process always stops at
00010419005A.
I have two questions:
* Why does the WAL file recovery process now stop after it reads
00010419005A?
* What do I need to do to get PostgreSQL to recover the rest of the
avail
As for clustering, unfortunately, it's a one-time operation in Postgres (as
far as I'm aware), so you'd have to "cluster" the index every time after an
insert or update of data. If it is partitioned, I presume it can be run on
the index of each partition table individually - but I'm not sure.
On
Heh, I honestly forgot about the recursive CTE. Certainly worth a try and
wouldn't require installing other extensions.
This is what depesz is referring to:
https://wiki.postgresql.org/wiki/Loose_indexscan
On Thu, Sep 23, 2021 at 3:04 AM hubert depesz lubaczewski
wrote:
> On Wed, Sep 22, 2021
22, 2021, at 1:50 PM, Ryan Booz wrote:
>
> Cool. I'd be interested to see the explain on it if you ever try it again.
> On that cardinality, I'd expect it to be really fast, so I'm interested to
> see if the (SkipScan) nodes were actually used.
>
>
> With timescaledb extensio
Cool. I'd be interested to see the explain on it if you ever try it again.
On that cardinality, I'd expect it to be really fast, so I'm interested to
see if the (SkipScan) nodes were actually used.
On Wed, Sep 22, 2021 at 5:35 PM Israel Brewster
wrote:
>
> On Sep 22, 2021, at 12:49 PM
be worth a shot. HTH
Ryan B
On Wed, Sep 22, 2021 at 4:27 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Wed, Sep 22, 2021 at 1:21 PM Michael Lewis wrote:
>
>> In the future, please share the plan returned by explain analyze, and
>> some data about how many r
Regarding hash partitioning, what is the function/algorithm that is used to
compute the hash for the partition key? I need to write a query like
“SELECT unknown_partition_hash_function(id) AS hash_value, COUNT(id) AS
number_of_records
FROM existing_table
GROUP BY 1”
Sent from
security fixes
over 10.1. There is no good reason to start a new project on an outdated
minor release with known security issues.
https://why-upgrade.depesz.com/show?from=10.1=10.9=
As Gavin asked, why not start on Pg11 with 11.4 being the current release?
Ryan Lambert
the
view in the proper schema.
PGOPTIONS='-c search_path=piws,public' sqitch deploy
Ryan
On Fri, Jun 8, 2018 at 8:27 AM, Adrian Klaver
wrote:
>
> Using INSTEAD OF trigger?:
>
Yep, that's one way.
> maybe it is time to overhaul the security concept.
>
I could see how I could revoke permissions from, say, all users that aren't
superusers to INSERT or UPDATE certain views. However, if possible it
would be nice to get an error message about the VIEW not being updatable,
rather than a user
;view".
Thanks!
Ryan
he first
> schema listed in search_path, then the query would not do what you
> want. You might want to consider prefixing the input parameter into
> get_inherited_tables with the schema name too.
>
Good point.
Thanks again!
Ryan
n on animal (
is_a_kind_of(tableoid::regclass, 'person') );
ERROR: index creation on system columns is not supported
I see that this is because "tableoid" is a system column. Does anyone know
any workaround for this? So close yet so far away!
Thanks!
Ryan
. a plpgsql
function that uses a temp table? What are the specific problems if I do
this? Is the problem ameliorated if I add ON COMMIT DROP?
Best,
Ryan
t comes up with only the text you wrote in your email, Tom.
I'm definitely not getting it... I thought maybe I had set these messages
to forward through my work email account, but I just verified that there is
no forwarding. I subscribed under the address at which I'm reading them.
Ryan
On Mon, No
Hi,
All right, so not for lack of trying, I cannot figure out how to
unsubscribe. I've tried three different things, but they've either been
ineffective or result in me getting an automatic email that the attempt
failed. Kindly help? I enjoyed my daily digest of PostgreSQL messages, but
this has
25 matches
Mail list logo
