Hi all,
I have a table with a little over 200,000 columns in it that I need
to update using a regular expression. I admit that though I am not a
beginner and postgres, I am also far from an expert. :p
I tried to create an Index that would optimize the UPDATE but I may
have made an error in
Philip Hallstrom wrote:
I'm not sure about this which is why I'm replying off list, but your
index is on file_type, file_parent_dir, and file_name and you're query
is on file_parent_dir and file_name.
I seem to remember reading that that the index will only get used if the
columns in the where
So I need to either find an Index that will work with regexes or
re-write my code to update each subdirectory separately and use simpler
UPDATE statement for each.
Why don't you use a LTREE type to model your directory tree ? It's been
designed specifically for this purpose and has